Ivan Voras <[EMAIL PROTECTED]> writes:
> I'm conducting some benchmarking (mostly for fun and learning), and one
> part of it is benchmarking PostgreSQL (7.4.1, on FreeBSD 4.9 and 5.2).
> I'm using pgbench from the contrib directory, but I'm puzzled by the
> results.
It is notoriously hard to g
First of, thanks, Tom.
Although I've been very careful on this kind of things, looks like I
missed one index on a referencing column. Still, I don't allow an entire
delete of a table if it has referencing columns with values, so at the
moment of the deletion, it has no rows at all.
I checked da
I'm conducting some benchmarking (mostly for fun and learning), and one
part of it is benchmarking PostgreSQL (7.4.1, on FreeBSD 4.9 and 5.2).
I'm using pgbench from the contrib directory, but I'm puzzled by the
results. I have little experience in benchmarking, but I don't think I
should be ge
Mark Kirkwood wrote a little unclearly:
And yes, I would recommend xfs - noticeably faster than ext3, and no
sign of any mysterious hangs under load.
I was thinking about the reported mini-hangs that folks are seeing with
jfs, except the all important keyword "jfs" didnt make it out of my he
Paul Ganainm <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] says...
>
>
>> XFS.. hands down.
>
>
> Off topic question here, but I'm a bit at a loss to understand exactly
> what sgi are doing.
>
>
> I thought that they were removing IRIX and going with Linux as the OS to
> their high end graphic
Hi
I have a php script and i make a pg_pconnect
If i want to make 4-10 pg_query in that script
Have i to close the connection at end of the script?
(i would say yes, is it right?)
Sorry I m a little bit confused about the persistent thing!!
Is it smart to use persistent connections at all if i ex
[EMAIL PROTECTED] says...
> XFS.. hands down.
Off topic question here, but I'm a bit at a loss to understand exactly
what sgi are doing.
I thought that they were removing IRIX and going with Linux as the OS to
their high end graphical workstations, yet I see they still have IRIX on
their
Mark Kirkwood wrote:
They seem pretty clean (have patched vanilla kernels + xfs for
Mandrake 9.2/9.0).
And yes, I would recommend xfs - noticeably faster than ext3, and no
sign of any mysterious hangs under load.
The hangs you are having are due to several issues... one of them is the
way ex
