Regards, Petr.
Tuning PostgreSQL is not just change the postgresql.conf, it includes
more things like:
- the filesystem that you are using
- the kernel version that you using (particularly in Linux systems)
- the tuning to kernel variables
- the type of discs that you are using (SSDs are very
On 10/11/2012 05:46 PM, Sergio Gabriel Rodriguez wrote:
Hi,
I tried with Postgresql 9.2 and the process used to take almost a
day and a half, was significantly reduced to 6 hours, before failing
even used to take four hours. My question now is, how long should it
take the backup for a
Regards, Nikolay.
Like Daniel said to you, I encourage to inform all your findings to the
LKML to
report all these problems.
Only one las t question: Did you tune the postgresql.conf for every
system? or
Did you use the default configuration ?
Best wishes
On 09/14/2012 04:45 AM, Daniel
Regards, Ross.
Dimitri Fontaine gave a excellent talk in the last PgCon about the
migration of Fotolog from MySQL to
PostgreSQL with amazing advices around this, so you can contact him for
his advice.
On 09/13/2012 02:11 PM, Ross Reedstrom wrote:
Hey PostgreSQL speed demons -
At work, we're
On 08/24/2012 05:47 AM, Felix Schubert wrote:
Hello List,
I've got a system on a customers location which has a XEON E5504 @
2.00GHz Processor (HP Proliant)
It's postgres 8.4 on a Debian Squeeze System running with 8GB of ram:
The Postgres Performance on this system measured with pgbench
On 04/04/2012 05:22 AM, ahchuan wrote:
Hi All,
I am new in using postgresSQL, I now support a system that been
running on postgressql. Recently I found that the database are
consuming the diskspace rapidly, it starting from 9GB and it now grow
until 40GB within 4-5 month.
I try to do a full
On 08/02/12 21:15, Peter van Hardenberg wrote:
Having read the thread, I don't really see how I could study what a
more principled value would be.
That said, I have access to a very large fleet in which to can collect
data so I'm all ears for suggestions about how to measure and would
gladly
On 09/02/12 00:09, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
You can execute several queries with the three different values provided
by Scott and Josh.
- SET random_page_cost = 2.0
First execution of the queries with EXPLAIN ANALYZE
- SET random_page_cost
On Wed, 2011-02-02 at 15:15 -0300, Cesar Arrieta wrote:
Hi, I have a Server with Fedora Core 11, Tomcat and Postgresql 8.3.
With Hardware:
* 8GB RAM
* 8 processors Intel Xeon E5520 @2.27GHz
* 250GB SATA DISK
Actually, it serves at most 250 connections.
The problem happends when it serves
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
El 07/05/2010 15:37, Mark Stosberg escribió:
Hello,
We've been a satified user of PostgreSQL for several years, and use it
to power a national pet adoption website: http://www.adoptapet.com/
Recently we've had a regularly-timed middle-of-the-night problem where
database handles are exhausted
El 07/05/2010 16:10, Mark Stosberg escribió:
You can use TRUNCATE instead DELETE. TRUNCATE is more efficient and
faster that DELETE.
Thanks for the suggestion. However, TRUNCATE is not compatible with
Slony, and we also have some rows which remain in table.
Now, we need more
El 06/05/2010 6:17, Neha Mehta escribi:
Hi,
I
am trying to have synchronous master-master replication in
PostgreSQL8.4 using PgPool II. I am not able to configure PgPool on the
system, it gives me an error, libpq is not installed or libpq is old.
I
have tried
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
This is very fast.
On IT Toolbox there are many whitepapers about it.
On the ERP and DataCenter sections specifically.
We need that all tests that we do, we can share it on the
Project Wiki.
Regards
On Nov 13, 2009, at 7:02 AM, Karl Denninger wrote:
Laszlo Nagy wrote:
Hello,
I'm about to
22 matches
Mail list logo