| 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: | Whole Thread | Raw Message | 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 |