Where does pgsql store the tables ??
От | HK |
---|---|
Тема | Where does pgsql store the tables ?? |
Дата | |
Msg-id | Pine.LNX.4.33.0209301308070.9243-100000@daisy.midascomm.com обсуждение исходный текст |
Ответ на | Re: Executing multiple statements in a single query? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Where does pgsql store the tables ??
|
Список | pgsql-novice |
hi tom, Thanx for the reply. Thats wat i am doing. The problem was i didnt wait for all the replies. I have two doubts. 1) When a table is created in the database, in wat file does pg store the data. Also where are the index files stored. 2) In asynchronous queries, can i dispense with pqflush(). If i can, what are all the cases where i can do so. On average my queries will be 8k in size. thanx in advance. -- regards hari On Wed, 25 Sep 2002, Tom Lane wrote: > HK <harikrishnan@midascomm.com> writes: > > I am using postgresql from a c application with asyncronous Query > > processing. Since only 1 query can be executed at a time, i am using a > > buffering mechanism to store the other queries generated at that time. Is > > there any way i can execute all the statements in the buffer with a single > > query. > > You can ship 'em all in a single PQsendQuery string, and wait for the > successive results to come back. Not sure if that's what you had in > mind... > > regards, tom lane >
В списке pgsql-novice по дате отправления: