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
> 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
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
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)), '+',
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
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 <[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
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
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
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
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
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
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
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
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
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
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
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
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
[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
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
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
"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'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
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
25 matches
Mail list logo