ob (inserting data)
Craig Ringer wrote:
>
> On 21/07/10 19:26, paladine wrote:
>>
>> Hi all
>> I prefer doing pg_dump - psql restore to vacuum full and
>> is there anyone know whether postgresql can insert data concurrently
>> while
>> restoring a ta
Hi all
I prefer doing pg_dump - psql restore to vacuum full and
is there anyone know whether postgresql can insert data concurrently while
restoring a table for not losing any data.
thanks in advance...
--
View this message in context:
http://old.nabble.com/pg_dump-restore-concurrency-tp29224
mn to integer again ?
Vick Khera wrote:
>
> On Wed, May 26, 2010 at 10:16 AM, paladine wrote:
>> Anyone know another method ?
>>
>
> options to reclaim disk space:
>
> vacuum full
> dump/restore (sometimes faster than vacuum full)
> cluster (not mvcc safe a
' and then run '
vacuum analyse verbose '
In your opinion, Is autovacuuming more efficient way ?
Steve Crawford wrote:
>
> On 05/26/2010 07:16 AM, paladine wrote:
>> Hi all,
>>
>> How can I reduce disk space postgresql used ?
>> I tried to del
ce though I run
this command
'delete from db ' ?
Thom Brown wrote:
>
> On 26 May 2010 15:50, paladine wrote:
>>
>> It is default value ( #checkpoint_segments = 3 # in logfile segments,
>> min
>> 1, 16MB each )
>> Many of my database configu
using shell scripts ( when the disk filled
up I delete it from db etc. )
Steve Crawford wrote:
>
> On 05/26/2010 07:50 AM, paladine wrote:
>> It is default value ( #checkpoint_segments = 3# in logfile segments,
>> min
>> 1, 16MB each )
>> Many of my database con
sed object (1GB size)
These are maybe normal operations but I don't understand that
although I delete many rows from my db and regularly vacuum , reindexing
operations,
how doesn't postgresql give back that deleted areas for reusing.
Thom Brown wrote:
>
> On 26 May 2010 15:16,
Hi all,
How can I reduce disk space postgresql used ?
I tried to delete many rows from my database and
I am running ' vacuum analyze reindexdb ' commands regularly
but my disk space on my linux machine didn't reduce.
I know that ' vacuum full ' command can do that but I don't want to use
that
