Try loading the data first and then create the indexes i recently loaded 50
Million rows in a table much bigger and it took about 1hour including the
creation of indexes .
Vasilis Ventirozos
---(end of broadcast)---
TIP 7: don't forget to incr
I've playing for a while with differents versions of postgreSQL (to
be exact, versions 7.2.2, 7.3.3 and 7.3.4) and I noticed that the only
one that dumped/restored correctly a database with blob's was version 7.3.4.
I made a dump by the book, without OID's. The restoration procedure
worked t
"Dennis Oudijk" <[EMAIL PROTECTED]> wrote:
> We run an apartment rental websites where people can post the rental
> properties that are available to rent.
>
> We currently have a statistics feature that provides landlords with
> information such as 'how many time has their property come up in a sea
I have some Gigs of useless transaction logs from databases that i have
created-droped etc..
can i recycle the logs or i have to run initdb again ?
Vasilis Ventirozos
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
Hi All,
I have 7.2.3 postgres database running. how to find that the multi-byte is enabled or
not for my database.
Regards,
Somasekhar Bangalore
Principal Software Engineer
ZenSutra Software Technologies Pvt. Ltd.
Suite 601, HM Geneva House
#14, Cunningham Road
Bangalore 560-052, India
Ph
[EMAIL PROTECTED] ("John Allgood") writes:
> I am looking for information on what operating systems and
> filesystems people are running postgresql on. I have read so much on
> this I decided to get some input from other people. I at first was
> leaning toward FreeBSD and using its filesyst
Vasilis Ventirozos <[EMAIL PROTECTED]> writes:
> I have some Gigs of useless transaction logs from databases that i have
> created-droped etc..
> can i recycle the logs or i have to run initdb again ?
They're supposed to be recycled automatically during checkpoints. What
PG version are you using
In the up and coming 7.4 version of PostgreSQL will it be possible for TRIGGER
functions be definable on a STATEMENT level rather than just ROW level?
Thanks in advance
Donald Fraser.
---(end of broadcast)---
TIP 2: you can get off all lists at on
We run an apartment rental websites where people can post the rental
properties that are available to rent.
We currently have a statistics feature that provides landlords with
information such as 'how many time has their property come up in a search'
and 'how many times have people clicked on the
Hi,
I think It has been answered before (talking about a post in 4/21).
Checking the forums for many times didn't help, so I have no other
choice but to ask you :
I'm trying to dump a DB with BLOB's on it. I'm using a Slackware 9.0
with postgreSQL 7.3.3. I have a single relation called 'fil
Hi All,
We have a development server running
OS – Linux, 2.4.20-openmosix-r4
DB – postgresql 7.3
We have a table ctcert_name under postgres
DB(postgres schema and postgres user is the owner). Suddenly, this object
started missing from the DB (I am the only
Person who connects to th
Some more info on the issue:
I checked the DB logs and there is no drop/rename
table statement in that.
I have the transaction logs, but not able
to read, as they are not in the human readable format.
How can I decipher from the txn logs, if
it captures the change management.
Thx
--Ra
On Wed, 17 Sep 2003, chakkara rangarajan wrote:
> Hi All,
>
> We have a development server running
>
> OS - Linux, 2.4.20-openmosix-r4
>
> DB - postgresql 7.3
>
>
>
> We have a table ctcert_name under postgres DB(postgres schema and postgres
> user is the owner). Suddenly, this object star
Hello Mr.scott,
Thx for the info and kind help. Can you please provide me any useful links
about the nature of the problem.
Rgds
--Ranga
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 10:26 AM
To: chakkara rangarajan
Cc: [EMAIL PROTEC
Well, if you're trying to run postgresql under openmosix, I'd suggest
looking into the archives of the postgresql-general and hackers mailing
list. note that this isn't a problem that has a fix in sight as far as I
know, i.e. there's a lot of work left to make it a functional solution,
and eve
P.s. just to be sure, are you running this under a mosix cluster, or a
single machine?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Wed, 17 Sep 2003, chakkara rangarajan wrote:
> Hi All,
>
> We have a development server running
>
> OS - Linux, 2.4.20-openmosix-r4
>
> DB - postgresql 7.3
>
>
>
> We have a table ctcert_name under postgres DB(postgres schema and postgres
> user is the owner). Suddenly, this object star
Hi list,
I have a table like this:
CREATE TABLE "gsames00" (
"ano_mes" varchar(6) NOT NULL,
"descricao" varchar(30),
PRIMARY KEY ("ano_mes")
);
and an index like this:
CREATE INDEX GSAMES01 ON GSAMES00 (ANO_MES);
When I run a explain analyze with this where claus
Rhaoni Chiu Pereira <[EMAIL PROTECTED]> writes:
> When I run a explain analyze with this where clause:
>... gsames00.ano_mes = to_char(ftnfco00.data_emissao,'MM') AND ...
> ...
> -> Seq Scan on gsames00 (cost=1.00..10006.72 rows=372 width=10)
> (actual time=0.01..0.96 row
Hello,
pgsql 7.3.2 on Linux 2.4.18:
I observe huge files (200Mb-1GB) in the database base dir which belong
to pg_toast__index relations. The itself is a pointer to a
user table relation which looks quite fine, not too big, say 2000 rows
with moderate data. These user tables are typically writte
Rhaoni Chiu Pereira wrote:
Hi list,
I have a table like this:
CREATE TABLE "gsames00" (
"ano_mes" varchar(6) NOT NULL,
"descricao" varchar(30),
PRIMARY KEY ("ano_mes")
);
and an index like this:
CREATE INDEX GSAMES01 ON GSAMES00 (ANO_MES);
When I run a explain an
Her goes:
Query:
SELECT /*+ */
ftnfco00.estado_cliente ,
ftcofi00.grupo_faturamento ,
SUM( DECODE( ftcofi00.atual_fatura, '-', -(NVL
(ftnfpr00.qtde_duzias,0)), '+', NVL(ftnfpr00.qtde_duzias,0), 0) ) ,
SUM( DECODE( ftcofi00.atual_fatura, '-', -(NVL(ftnfpr00.vlr_liquido,0)), '+',
Dirk Lutzebaeck <[EMAIL PROTECTED]> writes:
> I observe huge files (200Mb-1GB) in the database base dir which belong
> to pg_toast__index relations.
Not too surprising...
> I tried to vacuum full the corresponding user table, reindex this
> table or even drop the indexes to no avail.
REINDEX sho
> I have 7.2.3 postgres database running. how to find that the multi-byte
> is enabled or not for my database.
You should have used --enable-multibyte option during configure. If you
had, you can use 'pg_config --configure' to ensure it.
regards,
bhuvaneswaran
---(end o
Title: Message
Hi,
We are using
postgresql 7.3.2 on lunux platform. We performed locking test as
follows via JDBC:
Started 2 concurrent
transaction with autocommit false and isolation
READ_COMMITTED :
Transaction
1:
===
Update row
1
Sleep for 30
seconds
commit:
Transac
25 matches
Mail list logo
