On Wed, 2011-09-21 at 13:01 +0600, AI Rumman wrote:
> I am using Postgresql 9.0.1.
>
> I REINDEXED both the indexes and table, but I did not find any change
> in wastedspace or wastedispace.
> Could you please tell me why?
you need to
1) either vacuum full or cluster the table
2) analyze the
On 03/18/2011 12:17 AM, Adarsh Sharma wrote:
Thanks , it works now ..:-)
Here is the output :
pdc_uima=# SELECT count(*) from page_content WHERE publishing_date like
'%2010%' and
pdc_uima-# content_language='en' and content is not null and isprocessable = 1
and
pdc_uima-# to_tsvector('engli
On 03/16/2011 05:13 AM, Adarsh Sharma wrote:
Dear all,
I am facing a problem while creating the index to make the below query run
faster. My table size is near about 1065 MB and 428467 rows.
explain analyze select count(*) from page_content where publishing_date like
'%2010%' and content_lang
On Thu, 2010-10-28 at 12:59 -0700, Ben wrote:
> explain analyze select * from foo join bar using (i);
vs
explain analyze select * from foo join bar using (i) where i=9;
On Wed, 2010-10-27 at 13:23 -0500, Jon Nelson wrote:
> set it to 500 and restarted postgres.
did you re-analyze?
On Wed, 2010-10-20 at 14:44 -0400, Dimi Paun wrote:
> Folks,
> is there a way I can log all SQL statements to a file, together with the
> time it took to execute them?
>
> --
> Dimi Paun
> Lattica, Inc.
This is controlled by settings in the postgresql.conf file.
see the appropriate doc page
On 10/10/2010 11:02 AM, Reid Thompson wrote:
On Sat, Oct 9, 2010 at 5:26 PM, Neil Whelchel
On the other hand, I copied a table out of one of my production servers that
has about 60,000 rows with 6 columns (numeric, numeric, bool, bool, timestamp,
text). The first numeric column has numbers
On 10/10/2010 6:29 AM, Neil Whelchel wrote:
On Saturday 09 October 2010 23:56:15 Craig Ringer wrote:
On 10/10/2010 11:02 AM, Neil Whelchel wrote:
On Saturday 09 October 2010 18:47:34 Scott Marlowe wrote:
On Sat, Oct 9, 2010 at 5:26 PM, Neil Whelchel
wrote:
I know that there haven been many
On Wed, 2010-02-03 at 20:42 +0530, Amitabh Kant wrote:
> Forgot to add that I am using Postgres 8.4.2 from the default ports of
> FreeBSD.
start with this page
http://www.postgresql.org/docs/8.4/static/kernel-resources.html
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresq
On 1/22/2010 2:27 PM, Richard Neill wrote:
DM wrote:
Is there any script/tool to identify if the table requires full
vacuum? or to re-index an existing index table?
http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html
The bucardo project has released its nagios plugins for PostgreSQL a
On Fri, 2009-08-14 at 14:00 -0400, Jeremy Carroll wrote:
> I am confused about what the OS is reporting for memory usage on
> CentOS 5.3 Linux. Looking at the resident memory size of the
> processes. Looking at the resident size of all postgres processes, the
> system should be using around 30Gb of
Erik Aronesty wrote:
I think, perhaps, autovac wasn't running on that machine.
Is there any way to check to see if it's running?
since it looks like stats are on too
http://www.network-theory.co.uk/docs/postgresql/vol3/ViewingCollectedStatistics.html
read the entry on pg_stat_all_tables
This may be of interest...
http://weblog.infoworld.com/yager/archives/2008/05/ahead_of_the_cu_4.html
-Original Message-
From: [EMAIL PROTECTED] on behalf of Andrzej Zawadzki
Sent: Fri 5/23/2008 6:41 AM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Quad Xeon or Quad Opteron?
H
MUNAGALA REDDY wrote:
Hi All,
We are using solaris 10 x86/AMD Opteron and postgresql
8.2 on SunFire X2100 , however performance is very
slow in contrast to linux debian in the same platform.
Is this normal?
Thanks & Regards
Mahi
http://www.google.com/search?q=postgresql+solaris+tuning&ie=utf-
Reid Thompson wrote:
MUNAGALA REDDY wrote:
Hi All,
We are using solaris 10 x86/AMD Opteron and postgresql
8.2 on SunFire X2100 , however performance is very
slow in contrast to linux debian in the same platform.
Is this normal?
Thanks & Regards
Mahi
http://www.google.com/search?q=postgr
try it with a table with 650K rows...
On Tue, 2007-06-12 at 15:32 +0200, Christo Du Preez wrote:
> Good day,
>
> I have noticed that my server never uses indexing. No matter what I do.
>
> As an example I took a table with about 650 rows, having a parentid
> field with an index on parentid.
>
>
On Sun, 2007-06-03 at 23:17 -0400, Tom Lane wrote:
> Douglas J Hunley <[EMAIL PROTECTED]> writes:
> > On Saturday 02 June 2007 11:25:11 Tom Lane wrote:
> >> Another thing that seems strange is that the 8.2 config file does not
> >> seem to have been processed by initdb --- or did you explicitly com
On Fri, 2007-01-05 at 04:10 +0100, Grega Bremec wrote:
> he main reason I'm writing this mail though, is to suggest you take a
> look
> at Oryx, http://www.oryx.com/; They used to have this product called
> Mailstore, which was designed to be a mail store using PostgreSQL as a
> backend, and has si
Using information found on the web, I've come up with some configuration
and tuning parameters for a server/db that we will be implementing. I
was wondering if I could generate some feedback as to configuration and
tuning so that I could compare my estimations with those of others.
Host is AIX
19 matches
Mail list logo
