- Original Message -
From: Roberto Mello <[EMAIL PROTECTED]>
To: xuyifeng <[EMAIL PROTECTED]>
Sent: Sunday, March 04, 2001 10:40 AM
Subject: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in
DB?
> On Sun, Mar 04, 2001 at 10:01:3
PostgreSQL hasn't a rewritten storage managent, this is a normal case.
Regards
XuYifeng
- Original Message -
From: "Alfred Perlstein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Mikheev, Vadim" <[EMAIL PROTECTED]>
Sent: Friday, Februar
s that you are
still in 80's, in that time, PC are mostly not connected together via Network, when we
need migrate data to
another PC, we should use floppy :(, this time I should use the barbarism method
again --- dump table to a
file then load the file to another database even they are on same server! maybe I
should write a stupid program to
do task periodically.
Regards,
XuYifeng
ide to use closure
source database
- SYBASE on linux, we havn't any other selections. :(
note that SYBASE and Informix both have 'update statistics' command, but they run it
fast in seconds,
not block any other user, this is pretty. ya, what's good technology!
XuYifeng
ide to use closure
source database
- SYBASE on linux, we havn't any other selections. :(
note that SYBASE and Informix both have 'update statistics' command, but they run it
fast in seconds,
not block any other user, this is pretty. ya, what's good technology!
XuYifeng
recently I have downloaded a pre-beta postgresql, I found insert and update speed
is slower then 7.0.3,
even I turn of sync flag, it is still slow than 7.0, why? how can I make it faster?
Regards,
XuYifeng
Hi,
how long is PG7.1 already in beta testing? can it be released before Christmas day?
can PG7.1 will recover database from system crash?
Thanks,
XuYifeng
Is "if" clause support in PG?
for example:
"drop table aa if exist"
"insert into aa values(1) if not exists select * from aa where i=1"
I would like PG support it.
---
XuYifeng
- Original Message -
From: John Huttley <[EMAIL PROTECTED]>
To: <[EM
ion 7.1 of PostgreSQL will live up to your expectations in this area.
>
> Andreas
>
Thanks,
---
XuYifeng
rofessional customer, corporation
user, we store critical
data into database, not your garbage data.
Regards,
XuYifeng
- Original Message -
From: Don Baccus <[EMAIL PROTECTED]>
To: Ron Chmara <[EMAIL PROTECTED]>; Mitch Vincent <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]
it to our
Server,
I always see myself as a customer, customer is always right.
Regards,
XuYifeng
- Original Message -
From: Don Baccus <[EMAIL PROTECTED]>
To: xuyifeng <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 11:16 PM
Subject: Re: [HACKERS
no doubt, I have touched some problems PG has, right? if PG is so good,
is there any necessary for the team to improve PG again?
Regards,
XuYifeng
- Original Message -
From: Don Baccus <[EMAIL PROTECTED]>
To: xuyifeng <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]
Hi,
how long is PG7.1 already in beta testing? can it be released before Christmas day?
can PG7.1 will recover database from system crash?
Thanks,
XuYifeng
Hi,
can anyone tell me when Postgresql 7.1 will be released?
thanks,
XuYifeng
I did VACUUM ANALYZE, there is no effect.
XuYifeng
- Original Message -
From: Don Baccus <[EMAIL PROTECTED]>
To: xuyifeng <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 22, 2000 10:51 AM
Subject: Re: [HACKERS] query plan optimizer bug
> At 10
Hi,
it's obviously there is a query plan optimizer bug, if int2 type used in fields,
the plan generator just use sequence scan, it's stupid, i am using PG7.03,
this is my log file:
-
stock# drop table a;
DROP
stock# create table a(i int2, j int);
CREATE
stock# create unique index idx_a o
all you guy unix?
under some shells, both * and ? are expanded to matched file names in current
directory by shell,
for example FreeBSD's csh.
you should use psql -\? to get help screen, this sucks,
"?" shouldn't be used as a help screen argument.
Regards,
XuYifeng
--
17 matches
Mail list logo
