Another advice is to look the presentation of Alexander Dymo, on the
RailsConf2009 called: Advanced Performance Optimization of Rails Applications
available on
http://en.oreilly.com/rails2009/public/schedule/detail/8615
This talk are focused on Rails and PostgreSQL, based on the development of
When you say that with a lot of concurrent access, queries get very slow, How
many concurrent connections to your server have you had?
more that max_connections´value?
If you want to have many concurrent connections, you should have consider to
use a pooling connection system like pgbouncer or
Which is the type of your application? You can see it on the Performance
Whackamole Presentation from Josh Berkus on the
PgCon 2009:
- Web application
- Online Transaction Processing (OLTP)
- Data WareHousing (DW)
And based on the type of your application, you can configure the
postgresql.conf
Query is :
SELECT distinct m.id,coalesce(m.givenname,''),
coalesce(m.midname,''),
m.surname from marinerstates ms,vessels vsl,mariner m
WHERE m.id=ms.marinerid and ms.vslid=vsl.id
ANDms.state='Active' and coalesce(ms.endtime,now())::date = '2006-07-15'
AND
Meena_Ramkumar escribió:
How to run vacuumdb and reindex for Postgres DB in a non-stop server? Will it
be made without shutting the server? If so, then what will be performance
degradation percentage?
To execute vacuum, you can´t stop the server, is another process of it.
If you are using a
Pierre C escribió:
On Tue, 09 Mar 2010 08:00:50 +0100, Greg Smith g...@2ndquadrant.com
wrote:
Scott Carey wrote:
For high sequential throughput, nothing is as optimized as XFS on
Linux yet. It has weaknesses elsewhere however.
When files are extended one page at a time (as postgres
elias ghanem escribió:
Hi,
I’m using postgresql 8.4
I need to install multiple postgresql dbs on one server but I have
some questions:
-Is there any problems (performance wise or other) if I have 10 to 15
DBs on the same server?
-Each DB needs 10 tablespaces, so if I create 10 different
Lorenzo Allegrucci escribió:
Matthew Wakeling wrote:
On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote:
Anyway, how can I get rid those idle in transaction processes?
Can I just kill -15 them or is there a less drastic way to do it?
Are you crazy? Sure, if you want to destroy all of the changes
Gurgel, Flavio escribió:
- Richard Neill rn...@cam.ac.uk escreveu:
Matthew Wakeling wrote:
We're about to purchase a new server to store some of our old
databases,
and I was wondering if someone could advise me on a RAID card. We
want
to make a 6-drive