Hi, Luke,
Luke Lonergan wrote:
Since PG's heap scan is single threaded, the seek rate is equivalent to a
single disk (even though RAID arrays may have many spindles), the typical
random seek rates are around 100-200 seeks per second from within the
backend. That means that as sequential
Hi all,
I was searching tips to speed up/reduce load on a Pg8 app.
Thank you for all your suggestions on the matter.
Thread is archived here:
http://www.mail-archive.com/pgsql-performance@postgresql.org/msg18342.html
After intensive application profiling and database workload analysis,
I
On Wed, Sep 20, 2006 at 11:09:23AM +0200, Cosimo Streppone wrote:
I scheduled a cron job every hour or so that runs an analyze on the
4/5 most intensive relations and sleeps 30 seconds between every
analyze.
This has optimized db response times when many clients run together.
I wanted to
Andrew wrote:
On Wed, Sep 20, 2006 at 11:09:23AM +0200, Cosimo Streppone wrote:
I scheduled a cron job every hour or so that runs an analyze on the
4/5 most intensive relations and sleeps 30 seconds between every
analyze.
This suggests to me that your statistics need a lot of updating.
Hi,
I am running bechmark test in a 50 GB postgresql database.
I have the postgresql.conf with all parameters by default.
In this configuration the database is very, very slow.
Could you please tell which is the best configuration?
My system:
Pentium D 3.0Ghz
RAM: 1GB
HD: 150GB SATA
Thanks in
I would start by reading this web page:
http://powerpostgresql.com/PerfList
There are probably some other web pages out there with similar information,
or you can check the mailing list archives for a lot of info. If those
places don't help, then you should try to indentify what queries are
I am running bechmark test in a 50 GB postgresql database.
I have the postgresql.conf with all parameters by default.
In this configuration the database is very, very slow.
Could you please tell which is the best configuration?
My system:
Pentium D 3.0Ghz
RAM: 1GB
HD: 150GB SATA
We
Markus,
On 9/20/06 1:09 AM, Markus Schaber [EMAIL PROTECTED] wrote:
Do you think that adding some posix_fadvise() calls to the backend to
pre-fetch some blocks into the OS cache asynchroneously could improve
that situation?
Nope - this requires true multi-threading of the I/O, there need to
Hi, Luke,
Luke Lonergan wrote:
Do you think that adding some posix_fadvise() calls to the backend to
pre-fetch some blocks into the OS cache asynchroneously could improve
that situation?
Nope - this requires true multi-threading of the I/O, there need to be
multiple seek operations
IMHO, AIO is the architecturally cleaner and more elegant solution.
We in fact have a project on the boards to do this but funding (as
yet) has not been found.
My $.02,
Ron
At 02:02 PM 9/20/2006, Markus Schaber wrote:
Hi, Luke,
Luke Lonergan wrote:
Do you think that adding some
On Wed, Sep 20, 2006 at 05:47:41PM +0200, Chris Mair wrote:
I am running bechmark test in a 50 GB postgresql database.
I have the postgresql.conf with all parameters by default.
In this configuration the database is very, very slow.
Could you please tell which is the best
Markus,
On 9/20/06 11:02 AM, Markus Schaber [EMAIL PROTECTED] wrote:
I thought that posix_fadvise() with POSIX_FADV_WILLNEED was exactly
meant for this purpose?
This is a good idea - I wasn't aware that this was possible.
We'll do some testing and see if it works as advertised on Linux and
12 matches
Mail list logo