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
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Firstly, congratulations on providing quite a large database on such a
> limited system. I think most people on such plans have tables with a
> few hundred to a thousand rows in them, not a million. Many of the
> people here are used to budgets a hundred
Miernik wrote:
Scott Marlowe <[EMAIL PROTECTED]> wrote:
won't ever run into. Why such an incredibly limited virtual machine?
Even my cell phone came with 256 meg built in two years ago.
Because I don't want to spend too much money on the machine rent, and a
48 MB RAM Xen is about all I can ge
A Dimecres 23 Juliol 2008, Miernik va escriure:
> I have a PostgreSQL database on a very low-resource Xen virtual machine,
> 48 MB RAM. When two queries run at the same time, it takes longer to
> complete then if run in sequence. Is there perhaps a way to install
> something like a query sequencer,
Scott Marlowe <[EMAIL PROTECTED]> wrote:
> Well, my guess is that by running under Xen you're already sacrificing
> quite a bit of performance, and running it with only 48 Megs of ram is
> making it even worse. But if your budget is $100 a year, I guess
> you're probably stuck with such a setup.
On Wed, Jul 23, 2008 at 2:32 PM, Miernik <[EMAIL PROTECTED]> wrote:
> Scott Marlowe <[EMAIL PROTECTED]> wrote:
>> won't ever run into. Why such an incredibly limited virtual machine?
>> Even my cell phone came with 256 meg built in two years ago.
>
> Because I don't want to spend too much money on
Scott Marlowe <[EMAIL PROTECTED]> wrote:
> won't ever run into. Why such an incredibly limited virtual machine?
> Even my cell phone came with 256 meg built in two years ago.
Because I don't want to spend too much money on the machine rent, and a
48 MB RAM Xen is about all I can get with a budget
Miernik wrote:
> I have a PostgreSQL database on a very low-resource Xen virtual machine,
> 48 MB RAM. When two queries run at the same time, it takes longer to
> complete then if run in sequence. Is there perhaps a way to install
> something like a query sequencer, which would process queries in a
On Wed, Jul 23, 2008 at 9:21 AM, Miernik <[EMAIL PROTECTED]> wrote:
> I have a PostgreSQL database on a very low-resource Xen virtual machine,
> 48 MB RAM. When two queries run at the same time, it takes longer to
> complete then if run in sequence. Is there perhaps a way to install
> something lik
I have a PostgreSQL database on a very low-resource Xen virtual machine,
48 MB RAM. When two queries run at the same time, it takes longer to
complete then if run in sequence. Is there perhaps a way to install
something like a query sequencer, which would process queries in a FIFO
manner, one at a
18 matches
Mail list logo
