http://deepsand.net/wehlym/pmlqhxn.vhofkltmbsmckxm
Mag Gam
7/21/2013 7:26:43 AM
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Purge meaning, stop postgresql, rm -rf $PGDATA, recreate the
environment, and start up postgresql again.
On Tue, Jan 18, 2011 at 8:32 AM, Bill Moran wrote:
> In response to Mag Gam :
>
>> Hi Andy,
>>
>> No, I don't shrink the database. I simply purge the whole thin
e never checked pg_locks. How
would I do that ?
On Sun, Jan 16, 2011 at 12:28 PM, Andy Colson wrote:
> On 01/16/2011 10:44 AM, Mag Gam wrote:
>>
>> I am running Redhat 5.2 Linux with Postgresql 8.4.4;
>>
>> When my disk space is 90% free the database performance is very
I am running Redhat 5.2 Linux with Postgresql 8.4.4;
When my disk space is 90% free the database performance is very good.
However, when it reaches close to 20% free the database performance is
bad. I know its bad because I see a lot of 'D' next to 'postgresql'
process when running top and I see a
Got it thanks!
On Fri, May 8, 2009 at 2:57 PM, Christophe wrote:
>
> On May 8, 2009, at 11:25 AM, John R Pierce wrote:
>>
>> you read your tables by column, rather than by row??
>> SQL queries are inherently row oriented, the fundamental unit of storage
>> is a 'tuple', which is a representatio
Is it possible to tweak (easily) Postgresql so the storage is column
oriented versus row-oriented? We would like to increase read
optimization on our data which is about 2TB.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
Hi All,
Planning to implement tsearch2 for my websitem and dbschema. I wanted to
know if there is a "Best practices" guide I should be following. While
reading about it, I noticed there were lot of 'gotchas' with this, such as
back-up/restore, Slony 1 replication issues, etc..
What do most people
Is it possible to isolate logging for each individual database?
For example, lets say I have 3 databases: db1, db2, db3. And I want to
log db activity (statements, login/logout, etc..) db1, db2, db3 like
$PGDATA/db1, $PGDATA/db2, $PGDATA/db3, respectively.
Currently everything is logged in $PGDAT
Is it possible to store an index in a different table? Instead of
keeping the index in a separate column, I have a separate table for
storing all indexes. I am trying to set up something like this:
UPDATE indexTable SET index1=to_tsvector('default',coalesce(Table1.Data,''));
This is currently not
Regarding, http://archives.postgresql.org/pgsql-general/2003-10/msg00956.php
Has there been any progress integrating aspell for tsearch2 over ispell?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
10 matches
Mail list logo
