Quoth John [EMAIL PROTECTED]:
As per subject, i'm considering migrating a database (still in
development) from MaxDB to postgresql. The main reason for this is
that the stored procedures (functions) in MaxDB are unreliable and
hard to debug, and that the JDBC driver is still experimental.
I
I just experienced the same problem [1] with 8.0.0beta2.
[1] http://archives.postgresql.org/pgsql-bugs/2004-08/msg00086.php
--
Georgi Chorbadzhiyski
http://georgi.unixsol.org/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to
Hello,
* On the size of arrays :
I did not find any info in the Docs on this.
How many bytes does an array take on disk ?
My bet would be 4 bytes for number of dimensions, 4 per dimension for the
length, and then the storage requirements of whatever's in the array.
If the
What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
thanks for any comments.
.V
--
Please post on Rich Internet Applications User Interface (RiA/SoA)
http://www.portalvu.com
---(end of broadcast)---
Dear Postgresql experts,
According to the documentation for MOVE, it returns the number of rows
that it has moved over. It seems to me that this is true for MOVE
FORWARD n, but not for MOVE RELATIVE n or MOVE ABSOLUTE n when it always
returns 1:
db= declare c scroll cursor for select * from
All,
There seems to be a bug in pg_dumpall:
For one of my dbs I've done:
ALTER DATABASE dbname SET search_path = mw, public;
If I do a pg_dumpall I get a line like:
ALTER DATABASE dbname SET search_path TO 'mw, public';
note the 's. It's also in a place in the dump before the mw schema is
Ennio-Sr wrote:
Further to my message of 3rd inst.
Following your suggestion and after reading some documents, I created
this sql script:
-
SELECT scheda_ltr,
case scheda_ltr
when 'T' then
select * from bib_lt;
else
'autore, titolo, editore from bib_lt;'
Marcel Groner wrote:
I have a problem with postgresql runnung on smp kernel.
setup:
master:
---
- Pentium 4 (hyperthreading)
- 2 GB Memory
- os: fedora core 1
- kernel: 2.4.22-1.2188.nptlsmp
- postgresql: 7.4.3-1PGDG
slave 1:
- Pentium 4 (hyperthreading)
- 2 GB Memory
- os: fedora
On Thursday 09 Sep 2004 6:26 pm, Vic Cekvenich wrote:
What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
Well, it depends upon lot of factors. There are few questions to be asked
here..
- What is your hardware and OS configuration?
- What type of
--- Daniel Secomb [EMAIL PROTECTED] wrote:
Hi,
I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and
I'm getting the following
error when I try and run a SQL query on a script:
Error -
/usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php
--
Line: 33
PostgreSQL said:
Sebastian Davancens wrote:
Hi everyone. Im having a problem with heritage. The situation is the following:
I have two tables, tbl_everyone and tbl_employees. tbl_employees
inherits from tbl_everyone.
In tbl_everyone, i store some information about everyone who is
related with the place where i
On Thu, Sep 09, 2004 at 07:56:20AM -0500, Vic Cekvenich wrote:
What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
thanks for any comments.
My experience with tsearch2 has been that indexing even moderately
large chunks of data is too slow to be
It be at least dual opteron 64 w 4 gigs of ram runing fedora with a huge
raid striped drives as single volume.
A similar system and types of querries would be this:
http://marc.theaimsgroup.com
So I guess a table scan.
.V
Shridhar Daithankar wrote:
On Thursday 09 Sep 2004 6:26 pm, Vic Cekvenich
TL == Tom Lane [EMAIL PROTECTED] writes:
TL Wes [EMAIL PROTECTED] writes:
There's more than 250 million rows. If I remember right, it's ballpark 25%
data reload, 75% index/foreign constraint rebuild. Pg_dumpall is something
like 3 hours or so.
TL FWIW, increasing sort_mem for the reload
Steve Atkins wrote:
What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
thanks for any comments.
My experience with tsearch2 has been that indexing even moderately
large chunks of data is too slow to be feasible. Moderately large
meaning tens of
Paul Thomas [EMAIL PROTECTED] writes:
On 09/09/2004 10:41 Oliver Jowett wrote:
JDBC gives you no way to ensure you only call cancel() on a running query
(there's a race between query execution returning and the call to
cancel()). Calling cancel() on a statement that's not currently executing
Believe it or not, we haven't gotten many requests for this feature,
partly because such corruption is so rare. Also, any checker isn't
going to find a change from Baker to Faker in a text field.
---
Wes wrote:
On 9/4/04
Phil Endecott [EMAIL PROTECTED] writes:
According to the documentation for MOVE, it returns the number of rows
that it has moved over.
That's a documentation bug. CVS tip has the correct explanation:
The count is the number of rows that a FETCH command with the same
On Wed, 25 Aug 2004 10:04:54 +0200 Michal Taborsky [EMAIL PROTECTED] sat
down, thought long and then wrote:
[EMAIL PROTECTED] wrote:
What is the most advisable version I should upgrade to? My top goal is
reliability. Do I have to install/reinstall or upgrade? Do I need to be
concerned of
Hi,
What's the best way to obtain the Julian day from a postgresql
date?
PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
I'm doing some date arithmetic with 1 day intervals and want
to, for example, round to the even
On 9/9/04 11:07 AM, Bruce Momjian [EMAIL PROTECTED] wrote:
Believe it or not, we haven't gotten many requests for this feature,
partly because such corruption is so rare. Also, any checker isn't
going to find a change from Baker to Faker in a text field.
Yep, unless you added a CRC (and
On 9/9/04 9:27 AM, Vivek Khera [EMAIL PROTECTED] wrote:
I shaved significant time from 7.4.x restores by bumping up the
checkpoint_segments to 50. My dumps currently take about 1.5 hours
over a 100Mbit ethernet (server is on gig ethernet, dumping client is
on 100Mbit).
Mine are already set
22 matches
Mail list logo