current file length) --- the caller always knows this already,
> having already done smgrnblocks(), so it's silly to do it over
> again inside mdextend. Net result: extension of a file now takes
> one lseek(SEEK_END) and a write(), not three lseeks and
ed by postgresql-7.1-1
libpq.so.2 is needed by postgresql-7.1-1
libpq.so.2.0 is needed by php-pgsql-3.0.15-2
--
John CoersIntrinsity, Inc.
[EMAIL PROTECTED] Austin, Texas
---(end of broadcast)---
TIP 4: Don't &#x
ng on
> the lock. John's trace only showed one active backend, so I figured
> that there shouldn't be any blockage.
Keep in mind that I only sent a sample of trace data to show the kind of
things I was seeing, not the entire process from end-to-end.
--
John Coers
,
disk access, etc. are not pegged, so what else is could be slowing me down?
--
John CoersIntrinsity, Inc.
[EMAIL PROTECTED] Austin, Texas
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
John Coers wrote:
>
> What do the commit_delay and commit_siblings options do?
>
> I am unable to find any documentation on them in Chap 3 or 9
> of the Admin manual or in the man page for postmaster.
>
> --
> John CoersIntrinsity, Inc.
> [EMAIL PROTECTED
What do the commit_delay and commit_siblings options do?
I am unable to find any documentation on them in Chap 3 or 9
of the Admin manual or in the man page for postmaster.
--
John CoersIntrinsity, Inc.
[EMAIL PROTECTED] Austin, Texas
---(end of
Does a COPY FROM block? In case I am using the wrong terminology,
what I need to know is if I have multiple clients performing COPY FROM...PQputline()
using asynchronous connections, will I lose data? Will the server simply execute
them serially?
---(end of broadcast)---
ry to reduce disk access. Am I missing
something? Are
there any other configurable kernal params that I need to know about? What exactly
will the sort
mem (-o "-S") buy me?
Thanks for your patience!
--
John CoersIntrinsity, Inc.
[EMAIL PROTECTED]
