[GENERAL] changing column from int4 to int8, what happens with indexes?

Hi, well, i think the answer is simple 'it works' but i am not sure. When i change the column type from int4 to int8, are the indexes still usable or do i have to drop the indexes and create them again? regards, David ---(end of broadcast)--- TIP 9

[GENERAL] PostgreSql replication with heterogeneous databases!

We would like to offer PostgreSql community, open source data replication solution – Daffodil Replicator.   Daffodil Replicator is open source enterprise-wide data replication solution that eliminates the complexity of sharing information among heterogeneous operating systems and database

[GENERAL] PostgreSQL users on webhosting

hello, we have some webhosting servers and we can start postgresql support... I need to create for one webhosting account one postgresql account, which will have access only to databases created byh this postgresql account. I know, that it is no problem in mysql... thanx, miso --

Re: [GENERAL] changing column from int4 to int8, what happens with indexes?

On Tue, Jan 04, 2005 at 09:47:30AM +0100, David Teran wrote: > well, i think the answer is simple 'it works' but i am not sure. When i > change the column type from int4 to int8, are the indexes still usable > or do i have to drop the indexes and create them again? What happened when you tried

Re: [GENERAL] changing column from int4 to int8, what happens with indexes?

On Tue, Jan 04, 2005 at 09:08:51AM -0700, Michael Fuhr wrote: > On Tue, Jan 04, 2005 at 09:47:30AM +0100, David Teran wrote: > > > well, i think the answer is simple 'it works' but i am not sure. When i > > change the column type from int4 to int8, are the indexes still usable > > or do i have t

Re: [GENERAL] hundreds of millions row dBs

> We're getting about 64 million rows inserted in about 1.5 hrs into a > table with a multiple-column primary key - that's the only index. > That's seems pretty good to me - SQL Loader takes about 4 hrs to do the > same job. As I recall, the last time we rebuilt our database, it took about 3 hours

Re: [GENERAL] hundreds of millions row dBs

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wes Sent: Tuesday, January 04, 2005 8:59 AM To: Guy Rouillier; pgsql-general@postgresql.org; Greer, Doug [NTK] Subject: Re: [GENERAL] hundreds of millions row dBs > We're getting about 64 million rows inser

Re: [GENERAL] hundreds of millions row dBs

Wes <[EMAIL PROTECTED]> writes: > As I recall, the last time we rebuilt our database, it took about 3 hours to > import 265 million rows of data. It then took another 16 hours to rebuild > all the indexes. Out of curiosity, what value of sort_mem were you using? (In PG 8.0, the sort memory setti

Re: [GENERAL] hundreds of millions row dBs

"Dann Corbit" <[EMAIL PROTECTED]> writes: > Here is an instance where a really big ram disk might be handy. > You could create a database on a big ram disk and load it, then build > the indexes. > Then shut down the database and move it to hard disk. Actually, if you have a RAM disk, just change t

[GENERAL] vacuum is failing

I've got a server running PostgreSQL-7.2.3 on RHAS-2.1. The version of Postgresql is *not* my choice, I would have gone with something much more current, but i digress. Running 'vacuumdb -a -z -v -f' has started failing: NOTICE: Index pg_toast_218644531_idx: Pages 1; Tuples 0. CPU 0.00s

Re: [GENERAL] PostgreSQL 8.0.0 Release Candidate 3

RC3 on Microsoft VirtualPC with Debian Testing passes all tests. Marc G. Fournier wrote: We're always looking to improve that list, so we encourage anyone that is running a platform not listed to please report on any success or failures with Release Candidate 3. Running a fresh install of Debian/

Re: [GENERAL] vacuum is failing

Lonni J Friedman <[EMAIL PROTECTED]> writes: > ERROR: No one parent tuple was found > Anyone have any suggestions on how to correct this? Shut down whatever long-running transaction is hanging around in the background. You wouldn't be getting this error if vacuum weren't trying to move a chain

Re: [GENERAL] hundreds of millions row dBs

To speed up load : - make less checkpoints (tweak checkpoint interval and other parameters in config) - disable fsync (not sure if it really helps) - have source data, database tables, and log on three physically different disks - have the temporary on a different disk too, or in ramdisk

Re: [GENERAL] vacuum is failing

On Tue, 04 Jan 2005 18:30:43 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Lonni J Friedman <[EMAIL PROTECTED]> writes: > > ERROR: No one parent tuple was found > > > Anyone have any suggestions on how to correct this? > > Shut down whatever long-running transaction is hanging around in the > bac

[GENERAL] calculating costs.

Hi all, I am doing experiments on a new operator I am writing as a C shared library function. 1) As part of the experimentation I need to know exactly how many blocks have been read/write when the algorithm ran. I need complete control over the process to run my simulations. I see that there are

[GENERAL] varchar vs text

Are there any differences between text and varchar? I found the following in the docs, which leads me to believe that there are no differences at all. Can someone please confirm this before I switch all my varchars to text? Tip: There are no performance differences between these three types, apart

Re: [GENERAL] [Fwd: How to use LISTEN / NOTIFY in a Perl program]

On Mon, Jan 03, 2005 at 09:43:20AM +0100, Thierry Missimilly wrote: > > I have spend some time to read the very interesting feature LISTEN / > NOTIFY. I have found a lot of documentation on how to use in psql but > nothing on how to use in Perl DBI program. I don't know if it works. > I'll be ve