Joel Mc Graw <[EMAIL PROTECTED]> writes:
> Assuming that the data is exactly the same, I'm wondering if it is
> better to store it in a single large table or many smaller tables.
> Right now I have upwards of 2000 tables, some containing upwards of
> 10,000 records, and each record contains a lar
On Thursday 07 March 2002 01:02, Peter Darley wrote:
> Ian,
> By better I guess I mean faster. I'm looking to get the most speed out of
> my database without having to invest in new hardware.
> Thanks,
> Peter Darley
Then I don't think the PostgreSQL binaries provided in any given distribut
Ian,
By better I guess I mean faster. I'm looking to get the most speed out of
my database without having to invest in new hardware.
Thanks,
Peter Darley
-Original Message-
From: Ian Barwick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 3:17 PM
To: Peter Darley; Pgsql
On Wednesday 06 March 2002 18:49, Peter Darley wrote:
> Friends,
> I'm wondering if there is a specific Linux distribution for the x86 that
> will provide a better PostgreSQL server than the other ones?
> Thanks,
> Peter Darley
Do you have a more precise definition of "better"?
If you mean
On Wed, 6 Mar 2002, Zhang, Anna wrote:
> Hi,
> I created a foreign key constraint on table referral like this:
>
> alter table referral add constraint fk_referral foreign key (handle)
> references domain (handle);
> create
>
> alter table referral drop constraint fk_referral restrict;
> ERROR: AL
How do you get the server into production state?
What does production state mean?
What parms need to be set for production state in the
postgresql.conf file or other file?
---(end of broadcast)---
TIP 1: subscribe and
Hi,
I created a foreign key constraint on table referral like this:
alter table referral add constraint fk_referral foreign key (handle)
references domain (handle);
create
alter table referral drop constraint fk_referral restrict;
ERROR: ALTER TABLE / DROP CONSTRAINT: fk_referral does not exist.
> "Andy" == Andy Ruhl <[EMAIL PROTECTED]> writes:
Andy> On Wed, 6 Mar 2002, Peter Darley wrote:
>> Andy, I've got nothing against FreeBSD, except that I'm familiar
>> with Linux and not with BSD. What is it about FreeBSD that is
>> going to make it faster than Linux? Any idea where I can fi
iirc redhat has been busy optimizing postgresql, but if you take the time
and sit down, and configure postgres, you can prolly make it just as speedy
on any distro.
just my .02
Matrix
- Original Message -
From: "Andy Ruhl" <[EMAIL PROTECTED]>
To: "Peter Darley" <[EMAIL PROTECTED]>
Cc:
Assuming that the data is exactly the same, I'm wondering if it is
better to store it in a single large table or many smaller tables.
Right now I have upwards of 2000 tables, some containing upwards of
10,000 records, and each record contains a large amount of text stored
in a varchar field.
Pr
On Wed, 6 Mar 2002, Peter Darley wrote:
> Andy,
> I've got nothing against FreeBSD, except that I'm familiar with Linux and
> not with BSD. What is it about FreeBSD that is going to make it faster than
> Linux? Any idea where I can find some comparative benchmarks?
> Thanks,
> Peter Darle
Andy,
I've got nothing against FreeBSD, except that I'm familiar with Linux and
not with BSD. What is it about FreeBSD that is going to make it faster than
Linux? Any idea where I can find some comparative benchmarks?
Thanks,
Peter Darley
-Original Message-
From: [EMAIL PROTECTE
Yeah, it's called FREEBSD. www.freebsd.org.
If you don't like that, go to www.netbsd.org.
Sorry, had to do it.
Andy
On Wed, 6 Mar 2002, Peter Darley wrote:
> Date: Wed, 6 Mar 2002 09:49:43 -0800
> From: Peter Darley <[EMAIL PROTECTED]>
> To: Pgsql-Admin <[EMAIL PROTECTED]>
> Subject: [ADMIN]
On Wed, Mar 06, 2002 at 09:57:48AM +0100, [EMAIL PROTECTED] wrote:
>
> Hi,
>
> What function does VACUUM play in 7.2 ? Since a normal VACUUM does not
> reclaim space, is it run only to update statistics ?
> Is VACUUM still very slow on very large tables (over 50GB) like in 7.1 ?
>
> Regards
>
> The "sameuser" part of this works now, since sameuser is a record
> matching constraint, not an authentication test.
>
> There has been some talk of adding a more flexible username-matching
> field to pg_hba (whereupon the file name would be inappropriate ;-))
> but no one's really done any wor
Friends,
I'm wondering if there is a specific Linux distribution for the x86 that
will provide a better PostgreSQL server than the other ones?
Thanks,
Peter Darley
---(end of broadcast)---
TIP 2: you can get off all lists at once with the u
Morten Sickel <[EMAIL PROTECTED]> writes:
> I am planning to upgrade a 7.1.3 installation to 7.2 on an old HP-box. When
> running the regression test, some strange errors occurs,
I use HPUX 10.20 every day, and I can assure you 7.2 passes its
regression tests for me. Perhaps something strange ab
Can anyone offer me some insight into a --fast switch that can be used to
improve speed on Poastgres inserts.
I have been vacuuming database often but still our inserts seem to take
quite a bit of time. Someone mentioned this switch to me but I cannot seem to
find any documentation on it.
tha
Dmitry Morozovsky <[EMAIL PROTECTED]> writes:
> There is no "fall-through" or "backup": if one record is chosen
> and the authentication fails, the following records are not
> considered.
> Are there any plans to loose this restriction?
No. I don't believe we could count on cl
Is there a shell script (or a call to a function) available to check the
existence of an index before it is dropped?
I'm reloading a set of tables, and I want to drop the index before the
COPY, then recreate it.
_
Herb Blacker
Database Administrator
ReCare, Inc.
[EMAIL PR
Hi there colleagues,
>From the Docs (Admin 4.1):
There is no "fall-through" or "backup": if one record is chosen
and the authentication fails, the following records are not
considered.
Are there any plans to loose this restriction? It would be very useful
to use e.g.
lo
Hi,
I am planning to upgrade a 7.1.3 installation to 7.2 on an old HP-box. When
running the regression test, some strange errors occurs, I get everyting
fine until:
*** 1007,1053
--- 1007,1095
-- Second we install the wall connectors
--
insert into WSlot values ('WS.001.1a', '001
Hi,
What function does VACUUM play in 7.2 ? Since a normal VACUUM does not
reclaim space, is it run only to update statistics ?
Is VACUUM still very slow on very large tables (over 50GB) like in 7.1 ?
Regards
Robert
---(end of broadcast)---
TIP
23 matches
Mail list logo
