From: | HK <harikrishnan(at)midascomm(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Where does pgsql store the tables ?? |
Date: | 2002-09-30 07:45:36 |
Message-ID: | Pine.LNX.4.33.0209301308070.9243-100000@daisy.midascomm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)midascomm(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-30 14:30:51 | Re: Where does pgsql store the tables ?? |
Previous Message | Mark Wilson | 2002-09-30 03:53:40 | Database Session Variables |