On Friday 24 October 2003 16:23, scott.marlowe wrote:
> Right, but NONE of the benchmarks I've seen have been with IDE drives with
> their cache disabled, which is the only way to make them reliable under
> postgresql should something bad happen. but thanks for the benchmarks,
> I'll look them ove
David Link wrote:
> Hi All,
>
> Where can I find minor release information between versions:
>
> 7.3.1 and 7.3.4.
See /HISTORY or the release docs --- same place you learn about major
releases.
> And when is 7.4 expected, and should I hold off before upgrading to
> 7.3.4?
>
> I looked around
On Fri, 24 Oct 2003, Michael Teter wrote:
> Here are some recent benchmarks on different Linux filesystems. As with
> any benchmarks, take what you will from the numbers.
>
> Note the Summary section, and then the detailed benchmark numbers (if
> you have a stomach for huge tables of pure numb
Teodor Sigaev wrote:
First one will be a bit faster
Diogo Biazus wrote:
Hi,
Is there any performance diference between the following SQL commands:
SELECT * FROM documents WHERE content_ix @@
to_tsquery('word1&word2|word3');
SELECT * FROM documents WHERE content_ix @@ to_tsquery('word1') AND
On Thu, 23 Oct 2003 16:02:03 GMT, Ron <[EMAIL PROTECTED]>
wrote:
> ALTER TABLE project ADD CONSTRAINT company_is_ta companyID
> REFERENCES company(companyID);
> (plus variations on the above, resulting in errors, all similar to:)
>ERROR: parser: parse error at or near "companyID" at c
Thanks much, that was my problem.
For the record, the debian package name (which took me a while to
determine) is:
libreadline4-dev
Thanks again.
MT
Doug McNaught wrote:
Michael Teter <[EMAIL PROTECTED]> writes:
Howdy.
I looked around for an answer to this, but I was unable to find one
th
> Given everything else you've tried, I think you might be on the right track
> here and somehow your environment variables are getting clobbered. How or why
> I couldn't say (I'd suspect Tomcat, but you say you can't even run the
> create-administator app).
Tomcat only uses the minor few and runs
Hi all,
Just wanted to know how postgres handles semaphores. Was hoping that i can
can use the locks defined in lwlock.h and lwlock.c . If i create a new
lock and then use LockAcquire and
LockRelease when I want a process to start and stop will this work?
Nailah
---(end
Nailah Ogeer wrote:
> Hi all,
> Just wanted to know how postgres handles semaphores. Was hoping that i can
> can use the locks defined in lwlock.h and lwlock.c . If i create a new
> lock and then use LockAcquire and
> LockRelease when I want a process to start and stop will this work?
Uh, well, we
Please CC me, I am not subscribed.
An imaginary SQL statement
INSERT INTO table FETCH ... FROM cursor;
looks almost the same as currently available
INSERT INTO table SELECT ...;
I tried it because I needed to insert a row in a table
after I DELETEd a set of rows, something like this:
BEGIN;
DECL
Just for another data point, the default on my Debian 2.4.23-pre4 box is:
/dev/hdg elevator ID3
read_latency: 128
write_latency: 512
max_bomb_segments: 0
--
greg
---(end of broadcast)
Dann Corbit wrote:
Unwrap this link (if your newsreader folds it) and click on it for hard
drive performance:
http://www.storagereview.com/php/benchmark/compare_rtg_2001.php?typeID=1
0&testbedID=3&osID=4&raidconfigID=1&numDrives=1&devID_0=232&devID_1=237&
devID_2=213&devID_3=221&devID_4=216&devID_
Peter Childs wrote:
On Mon, 20 Oct 2003, Shridhar Daithankar wrote:
A fast HD with a good RAID controller. Subject to budget, SCSI are beter buy
than IDE. So does hardware SCSI RAID.
I hate asking this again. But WHY?
OK.. There are only few SCSI disks that I have handled so take it with grain o
On Mon, Oct 20, 2003 at 01:03:23PM -0400, Daniel E. Fisher wrote:
> After reading all my server logs:
>
> No error messages or nothing. Weird..
Including Apache's /var/log/httpd/access_log and
/var/log/httpd/error_log during restart?
(or wherever you may have moved them)
> May have something to
Title: RE: [GENERAL] how to use pg_resetxlog
--Thanks to all that replied
--I did the pg_resetxlog -f $PGDATA and
--it generated a new log, but when I try to
--restart the database, it fails. I look in the
--logs and I see:
[snip]
Oct 21 01:32:13 localsvr postgres[2598]: [1] FATAL 2:
c
On Thursday 23 October 2003 11:38, Birahim FALL wrote:
> Is such a product exists (preferably opensource).
> I'm ready to go for python etc, but I really wuld have to re-educate
> myself.
Bir,
There are a LOT of ways to make web pages with data from Postgres.
I'd suggest you get:
The latest
Ben-Nes Michael wrote:
But still the greatest question is what FS to put on ?
I heard Reiesref can handle small files very quickly.
Switching from ext3 to reiserfs for our name servers reduced the time
taken to load 110,000 zones from 45 minutes to 5 minutes.
However for a database, I don't thi
Unwrap this link (if your newsreader folds it) and click on it for hard
drive performance:
http://www.storagereview.com/php/benchmark/compare_rtg_2001.php?typeID=1
0&testbedID=3&osID=4&raidconfigID=1&numDrives=1&devID_0=232&devID_1=237&
devID_2=213&devID_3=221&devID_4=216&devID_5=249&devID_6=250&de
Hello
PostgreSQL doesn't support h.q and I will not support this type of h.q.
Supported syntax will be like db2 - ANSI SQL 2kx. But you can try hier
patch - http://gppl.terminal.ru/readme.html.
This is a patch which allows PgSQL to perform hierarchical queries like
Oracle does.
Regards
Pavel
I get this when I try to start up a freshly compiled beta4 on OS X
10.2.6:
FATAL: could not create shared memory segment: Invalid argument
I saw a previous thread on this for beta2. It sounded like this was a
bug that was to be fixed in beta3, but I'm still having this problem
with beta4.
Th
Have you tried placing the jars in the $JAVA_HOME/jre/lib/ext
directory? Jars there
are automatically searched by the JVM.
On Thursday, October 23, 2003, at 01:52 PM, Richard Huxton wrote:
On Thursday 23 October 2003 18:07, Ashwin Kutty wrote:
Now, the postgresql.jar gets pointed to twice; once
Cláudia Morgado <[EMAIL PROTECTED]> writes:
> Oracle has the option with the SQL CONECT BY statement to run through a
> hierarchical database with a single SQl-statement:
Not really.
There is a package in the contrib directory called tablefunc that has a
function called connect_by that can do
On Thu, Oct 23, 2003 at 05:55:10PM -0500, Chris M. Gamble wrote:
> update replicated to all others. It looked as though I could
> only update at 1 server.
That's right. At the moment, AFAIK, nobody can offer what you want,
although I have heard suggestions otherwise. The distance tha
On Thu, Oct 23, 2003 at 07:53:08PM -0300, Martin Marques wrote:
> El Jue 23 Oct 2003 19:41, Chris M. Gamble escribi?:
> > I am trying to perform what I best understand as Multi-master asynchronous
> replication for postgres 7.3.3 servers. After researching, I tried the
> 1) I think the best shot
Jeff,
thank you for the time and suggestion.
I'm also trying to use SETOF custom_type as a solution
Oksana
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Fri, Oct 24, 2003 at 07:25:44AM +0200, Pavel Stehule wrote:
> Not
>
> SELECT 1 as a, a*2;
> ERROR: column "a" does not exist
But you can try
SELECT a, a*a FROM (select 1 as a);
> On Tue, 21 Oct 2003, Bob Messenger wrote:
>
> > Is it possible to do something like:
> >
> > select 1 as a
Ben-Nes Michael wrote:
- Original Message -
From: "Nick Burrett" <[EMAIL PROTECTED]>
Ben-Nes Michael wrote:
But still the greatest question is what FS to put on ?
I heard Reiesref can handle small files very quickly.
Switching from ext3 to reiserfs for our name servers reduced the time
> -Original Message-
> From: Stephen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 22, 2003 9:02 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] SCSI vs. IDE performance test
>
>
> The SCSI improvement over IDE seems overrated in the test. I
> would have expected at most a 30
Ron,
I have done this by adding the attribute to the table with nulls allowed and adding a
constraint to the table for the foreign key... works like a charm:
CREATE TABLE TESTTYPE (
TESTTYPEKEY char(30) NOT NULL,
TESTTYPENAME varchar(255) NULL,
TESTTYPEDESC
Hello
Can I use tsearch2 with aspell? I didn't find any info about it, and I
don't know anything about difference between ispell and aspell.
Thank You
Pavel Stehule
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregi
- Original Message -
From: "Shridhar Daithankar" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>
Cc: "Nick Burrett" <[EMAIL PROTECTED]>; "postgresql"
<[EMAIL PROTECTED]>
Sent: Monday, October 20, 2003 3:06 PM
Subject: Re: [GENERAL] Recomended FS
> Ben-Nes Michael wrote:
>
>
Nick Burrett <[EMAIL PROTECTED]> writes:
> I expected that specifying a specific length for a column would allow
> for more efficient indexing and searching because:
> a) you already know the exact length of the column
> b) potentially the column-data could be stored starting on a word-boundary
>
On 22/10/2003 14:36 frbn wrote:
hi,
it seems you use the /usr/bin/pg_dumpall featured by the redhat default
install
verify this with "which pg_dumpall"
(rpm -ql postgresql to see all the files of this package)
you upgraded from sources didn't you ?
your fresh new install has the default prefix /
My sysadmin just called and tol me he updated the php.rpm... he happens to
be in California totally
across the US from me for a week...
So I check the ver and...
Php version 4.1.2-7.2.6 recently updated - yesterday
Postgresql 7.3.3 installed in august sometime - upgraded from basic redhat
7.2 post
> I can't get a rest for a min guys.
>
> I go away for the weekend and my server is getting this error.
>
> Fatal error: Call to undefined function: pg_connect() in
> /var/www/html/crohns/phpBB2/db/postgres7.php on line 79
Your PHP doesn't have support for PostgreSQL.
Look at phpinfo();
--->
>
35 matches
Mail list logo
