On Fri, Apr 8, 2011 at 12:13 PM, Lukasz Brodziak
wrote:
> Hello,
>
> Is there a way to reiindex whole pg_catalog instead of reindexing each
> table?
>
>
You can achieve this by using below command::
postgres@raghu:/opt/PostgreSQL/8.3/bin$ ./reindexdb -s test -p 5433
[or]
postgres=# reindex syst
Thanks for the info Tom.
The table has been analyzed (somewhat repeatedly...), with the stats
target set at various limits.
At the moment default_statistics_target = 50.
I've had work_mem as low as 1MB and as high as 128MB, with little to no
avail.
Setting enable_hashagg = off, does allow the
Attempting to run a backup with the database online. I first issue
'PG_START_BACKUP', then copy the contents of the postgresql data folder,
then issue 'PG_STOP_BACKUP'. The database service remains running during the
copy. If queries continue to hit the database after the PG_START_BACKUP
command is
Thanks for the suggestion, however; this query runs in under 2 minutes (big
data set) on the server it originated from, and I’m trying to ascertain why
there is such a difference in performance between what should be two like for
like server, as there are many other queries of a similar nature
Hello,
Is there a way to reiindex whole pg_catalog instead of reindexing each table?
--
Łukasz Brodziak
"What if everyting around You isn't quite as it seems,
What if all the world You think You know is an inelaborate dream
When You look at Your reflection is that all you want it to be
What if Y
--- On Thu, 4/7/11, H S wrote:
From: H S
Subject: Re: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db
To: "raghu ram"
Date: Thursday, April 7, 2011, 9:07 PM
CREATE USER statement to create and configure a database user,which is an
account through which you can log into the data
"French, Martin" writes:
> I am having problems with a query on 8.1 running on
> RHEL 5.4
> work_mem = 98394
> The explain (cannot explain analyze, or Postgres runs out of memory
> again)
> 'HashAggregate (cost=2731947.55..2731947.57 rows=1 width=38)'
> ' -> Seq Scan on stkl_rec (cost=0.00..
Gerhard Hintermayer wrote:
> I'm trying to set up at least 3 servers using hot standby
> streaming replication. I'd like to have one primary and 2
> secondary (on 2 different locations in case of a desaster in the
> server room).
> A primary
> B secondary 1
> C secondary 2 (on a different locati
Have you tried moving the FROM ... WHERE ... into a sub-select? GROUP BY uses
HAVING, not WHERE.
- Reply message -
From: "French, Martin"
Date: Wed, Apr 6, 2011 7:44 pm
Subject: [ADMIN] Out Of Memory 8.1
To:
Hi All,
I am having problems with a query on 8.1 running on
RHEL 5.4
16GB
> You can install two different versions of PostgreSQL in different
> directories, or you can run pg_dump from the machine which is your
> conversion target. We do both. We always build from source, and we
> use a --prefix on configure which includes the version. For
> example:
I even tried out
Hi,
I'm trying to set up at least 3 servers using hot standby streaming
replication. I'd like to have one primary and 2 secondary (on 2
different locations in case of a desaster in the server room).
A primary
B secondary 1
C secondary 2 (on a different location that A and B)
Are the following acti
Hi All,
I am having problems with a query on 8.1 running on
RHEL 5.4
16GB RAM
Linux pgsql3 2.6.18-164.el5PAE #1 SMP Tue Aug 18 15:59:11 EDT 2009 i686
i686 i386 GNU/Linux
2 x Xeon X5650 (2.67GHz 6 Cores)
Disks are on PERC 6 controller in RAID 10
Postgresql.conf:
# - Memory -
shared_buffers = 32
12 matches
Mail list logo
