On Thu, Jul 31, 2008 at 11:45 AM, Matthew T. O'Connor <[EMAIL PROTECTED]> wrote:
> Interesting read...
>
> http://www.linux.com/feature/142658
Wish he had used a dataset larger than 1G...
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscr
Mark Roberts wrote:
On Wed, 2008-07-30 at 13:51 -0400, Tom Lane wrote:
Huh? Vacuum doesn't block writes.
regards, tom lane
Of course, you are correct. I was thinking of Vacuum full, which is
recommended for use when you're deleting the majority of rows in a
Interesting read...
http://www.linux.com/feature/142658
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Wanted to install pgbouncer, but it is broken currently in Debian. And
why is it in contrib and not in main (speaking of Debian location)
Pgbouncer has worked very well for us. Wasn't available in default repos
for Ubuntu server when I did my original setup but installing from
source is quit
Miernik wrote:
> BTW, doesn't there exist any tool does what "psql -c" does, but is
> written in plain C, not perl? I was looking for such psql replacement,
> but couldn't find any.
As others have noted, psql is written in C, and you're using a wrapper.
Assuming your're on Debian or similar you
On 31 Jul 2008, at 11:17AM, Miernik wrote:
Theo Kramer <[EMAIL PROTECTED]> wrote:
file `which psql`
/usr/bin/psql: ELF 32-bit LSB executable, Intel 80386, version 1
(SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.9,
stripped
[EMAIL PROTECTED]:~$ file `which psql`
/usr/bin/ps
Miernik wrote:
Theo Kramer <[EMAIL PROTECTED]> wrote:
file `which psql`
/usr/bin/psql: ELF 32-bit LSB executable, Intel 80386, version 1
(SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.9,
stripped
[EMAIL PROTECTED]:~$ file `which psql`
/usr/bin/psql: symbolic link to `../s
Theo Kramer <[EMAIL PROTECTED]> wrote:
> file `which psql`
> /usr/bin/psql: ELF 32-bit LSB executable, Intel 80386, version 1
> (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.9,
> stripped
[EMAIL PROTECTED]:~$ file `which psql`
/usr/bin/psql: symbolic link to `../share/postgr
Miernik wrote:
Richard Huxton <[EMAIL PROTECTED]> wrote:
I just installed pgpool2 and whoaaa! Everything its like about 3 times
faster! My application are bash scripts using psql -c "UPDATE ...".
Probably spending most of their time setting up a new connection, then
clearing it down again.
If
On 31 Jul 2008, at 10:29AM, Miernik wrote:
Richard Huxton <[EMAIL PROTECTED]> wrote:
I just installed pgpool2 and whoaaa! Everything its like about 3
times
faster! My application are bash scripts using psql -c "UPDATE ...".
Probably spending most of their time setting up a new connection,
Richard Huxton <[EMAIL PROTECTED]> wrote:
>> I just installed pgpool2 and whoaaa! Everything its like about 3 times
>> faster! My application are bash scripts using psql -c "UPDATE ...".
>
> Probably spending most of their time setting up a new connection, then
> clearing it down again.
If I do i
Miernik wrote:
Might be worth turning off autovacuum and running a manual vacuum full
overnight if your database is mostly reads.
I run autovacum, and the database has a lot of updates all the time,
also TRUNCATING tables and refilling them, usually one or two
INSERTS/UPDATES per second.
OK
12 matches
Mail list logo
