Hi:
I have to update all the records of a table. I'm worried about what the table
will look like in terms of fragmentation when this is finished. Is there some
sort of table healing/reorg/rebuild measure I should take if I want the
resulting table to operate at optimal efficiency? What about
On Thu, 2011-03-03 at 20:03 -0700, Gauthier, Dave wrote:
> Hi:
>
> I have to update all the records of a table. I'm worried about what
> the table will look like in terms of fragmentation when this is
> finished. Is there some sort of table healing/reorg/rebuild measure I
> should take if I want
On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote:
> Hi:
>
> I have to update all the records of a table. I'm worried about what the
> table will look like in terms of fragmentation when this is finished. Is
> there some sort of table healing/reorg/rebuild measure I should take if
On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote:
> On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote:
>> Hi:
>>
>> I have to update all the records of a table. I'm worried about what the
>> table will look like in terms of fragmentation when this is finished. Is
>> there some
On 03/04/2011 04:54 AM, Vibhor Kumar wrote:
>
> On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote:
>
>> On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote:
>>> Hi:
>>>
>>> I have to update all the records of a table. I'm worried about what the
>>> table will look like in terms of
AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] updating all records of a table
On 03/04/2011 04:54 AM, Vibhor Kumar wrote:
>
> On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote:
>
>> On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote:
>>> Hi:
>&g
robjsarg...@gmail.com (Rob Sargent) writes:
> On 03/04/2011 04:54 AM, Vibhor Kumar wrote:
>>
>> On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote:
>>
>>> On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote:
Hi:
I have to update all the records of a table. I'm worried ab
This has been a great thread! I am missing something because I do not
know what CTAS is. WOuld someone please help me understand.
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Mar 05, 2011 at 07:38:23AM -0800, ray wrote:
> This has been a great thread! I am missing something because I do not
> know what CTAS is. WOuld someone please help me understand.
Create Table As Select.
Have a nice day,
--
Martijn van Oosterhout http://svana.org/kleptog/
> Patriot
you might consider lowering the fillfactor a bit. It will consume more
space, but it will make updates and inserts faster.
http://www.postgresql.org/docs/8.4/interactive/sql-createtable.html :
fillfactor (integer)
The fillfactor for a table is a percentage between 10 and 100. 100 (complete
packin
10 matches
Mail list logo