On Monday 21 November 2005 12:12, you wrote:
> On Mon, Nov 21, 2005 at 09:41:36AM -0500, Michael D. Sofka wrote:
> You're talking about a 16G database that you expect to grow to 64G. That
> would fit happily in a RAID1 (mirror) of two SCSI 72G drives. I haven't
> priced that kind of stuff out recen
Hi,
I use Postgresql 8.03/ 8.04 on windows xp with sp2, all have same problems.
run the windows cmd by:
runas /user:postgres cmd
and run the initdb program like:
initdb --locale=C --username=postgres -W -A md5 -E UNICODE -D ../data
then it says:
creating directory ../data/ ... ok
creating di
Hi:
I did the following after installing the pgstattuple contrib code:
select * from pgstattuple('wind');
-[ RECORD 1 ]--+--
table_len | 224854016
tuple_count| 1492601
tuple_len | 207535124
tuple_percent | 92.3
dead_tuple_count | 11569
dead_tuple_len
Hi:
I have a 440 million row table that I'm attempting to partition. The
table is named 'pressure' and holds pressure data from an undersea
sensor measuring wave height.
The sensor reports every half second.
The partitions are named 'p0', 'p1' ... 'pN' and are divvied according
to measure
On 11/24/05, Colton Smith <[EMAIL PROTECTED]> wrote:
My question: when you vacuum a table and generate 'free_space', who isallowed to consume this 'free_space'? Is it released to the OS forgeneral use? Or is it reserved just for the database? If the latter, isit reserved just for 'wind' (in this ca
"Johnson Zhao" <[EMAIL PROTECTED]> wrote
>
> run the windows cmd by:
>
> runas /user:postgres cmd
>
> and run the initdb program like:
>
> initdb --locale=C --username=postgres -W -A md5 -E UNICODE -D ../data
>
> then it says:
>
> creating directory ../data/ ... ok
> creating directory ../data/glo
Johnson Zhao wrote:
Hi,
I use Postgresql 8.03/ 8.04 on windows xp with sp2, all have same problems.
run the windows cmd by:
runas /user:postgres cmd
and run the initdb program like:
initdb --locale=C --username=postgres -W -A md5 -E UNICODE -D ../data
then it says:
creating directory ../d
