Il Friday 26 October 2007 15:18:04 Tom Lane ha scritto:
Reg Me Please [EMAIL PROTECTED] writes:
(cost=3.95..382140.91 rows=274709 width=91) (actual
time=1.929..57713.305 rows=92 loops=1)
Hash Cond: (t_dati.camp_id = t_campi.camp_id)
I think the reason it doesn't want to use an indexed
Reg Me Please [EMAIL PROTECTED] schrieb:
How can I Increasing the statistics target for the larger table?
I'ìm sorry for asking, but I'm not that deep into RDBMS.
alter table table alter column column SET STATISTICS value;
Andreas
--
Really, I'm not out to destroy Microsoft. That will just
Il Saturday 27 October 2007 08:51:09 Andreas Kretschmer ha scritto:
Reg Me Please [EMAIL PROTECTED] schrieb:
How can I Increasing the statistics target for the larger table?
I'ìm sorry for asking, but I'm not that deep into RDBMS.
alter table table alter column column SET STATISTICS value;
Hi all,
I've read everything in this subject you guys has discussed already
(including topic started by Max Zorloff) but I haven't found my answer yet.
I'm looking for hints on best configuration for my specific needs: I'm
having complied program written in C, which reads lots of data from
On Fri, 2007-10-26 at 14:39 -0700, Jeff Davis wrote:
On Fri, 2007-10-26 at 15:08 -0600, Brian Wipf wrote:
I have a test PG 8.2.5 installation that has been left idle with no
connections to it whatsoever for the last 24 hours plus. WALs are
being archived exactly 5 minutes apart, even
Reg Me Please [EMAIL PROTECTED] schrieb:
Il Saturday 27 October 2007 08:51:09 Andreas Kretschmer ha scritto:
Reg Me Please [EMAIL PROTECTED] schrieb:
How can I Increasing the statistics target for the larger table?
I'ìm sorry for asking, but I'm not that deep into RDBMS.
alter table
I have a lot of code -- millions of lines at this point, written
over the last 5 years. Everything is in a bunch of nested folders.
At least once a week, I want to find some code that uses a few modules,
so I have to launch a find + grep at the top of the tree and then wait
for it to finish.
I
Wojtek Mach wrote:
Hi all,
I've read everything in this subject you guys has discussed already
(including topic started by Max Zorloff) but I haven't found my answer yet.
I'm looking for hints on best configuration for my specific needs: I'm
having complied program written in C, which reads
Simon Riggs [EMAIL PROTECTED] writes:
We *could* force it to perform a log switch whether or not new WAL has
been written.
That would be a truly awful idea.
I think the right answer for Kevin's situation really is to be doing a
dummy transaction every few minutes as one component of his system
Matthew Wilson [EMAIL PROTECTED] writes:
At least once a week, I want to find some code that uses a few modules,
so I have to launch a find + grep at the top of the tree and then wait
for it to finish.
Personally I use glimpse for this. It's a bit old and creaky but it
performs wonders.
openfts.sf.net is tool for you. It has even example scripts for
indexing/searching file system.
Oleg
On Sat, 27 Oct 2007, Matthew Wilson wrote:
I have a lot of code -- millions of lines at this point, written
over the last 5 years. Everything is in a bunch of nested folders.
At least once a
Pat Maddox wrote:
On 10/26/07, brian [EMAIL PROTECTED] wrote:
Pat Maddox wrote:
On 10/26/07, brian [EMAIL PROTECTED] wrote:
SELECT * FROM posts ORDER BY root_id, id;
brian
---(end of broadcast)---
TIP 4: Have you searched our list archives?
For some odd reason, Rails decided to call createdb as:
createdb foo_database -E utf8
On my Mac systems, this work. On my AIX system it does not. I get:
createdb dog -E utf8
createdb: too many command-line arguments (first is utf8)
Try createdb --help for more information.
Has anyone else
Hi,
lately I have been looking at difference between a Stored Proc and User
Defined Functions in other RDBMS like Sql Server / Oracle.
However, in postgresql, I think Stored Procs are wrapped around in User
Defined functions, if I am not wrong.
The following is the list of main differences b/w a
On Oct 27, 2007, at 12:56 , Perry Smith wrote:
On my Mac systems, this work. On my AIX system it does not. I get:
Versions?
Michael Glaesemann
grzm seespotcode net
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
On Oct 27, 2007, at 1:41 PM, Michael Glaesemann wrote:
On Oct 27, 2007, at 12:56 , Perry Smith wrote:
On my Mac systems, this work. On my AIX system it does not. I get:
Versions?
My AIX is 5.3 close to the latest. Postgres is 8.2.4 I built all of
the open source stuff myself using
Michael Glaesemann [EMAIL PROTECTED] writes:
On Oct 27, 2007, at 12:56 , Perry Smith wrote:
On my Mac systems, this work. On my AIX system it does not. I get:
Versions?
I think the old shell-script version of createdb, in 7.3 and before,
might have taken that ordering of arguments ...
On Sat, Oct 27, 2007 at 12:56:37PM -0500, Perry Smith wrote:
On my Mac systems, this work. On my AIX system it does not. I get:
createdb dog -E utf8
createdb: too many command-line arguments (first is utf8)
Try createdb --help for more information.
Has anyone else bumped in to this? Is
I would like to try PostgreSQL 8.3 without uninstalling version 8.1.
Is this possible??
Bob Pawley
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On 27/10/2007 22:05, Bob Pawley wrote:
I would like to try PostgreSQL 8.3 without uninstalling version 8.1.
Is this possible??
Hi Bob,
Yes, it is - it's usually a matter of putting the two versions to listen
on two different ports. I haven't done it myself, but this crops up from
time to
On 10/27/07, Bob Pawley [EMAIL PROTECTED] wrote:
I would like to try PostgreSQL 8.3 without uninstalling version 8.1.
Is this possible??
Sure. If you're on Unix, download the source and install it somewhere
in, say, your home directory. This requires a certain familiarity with
the shell,
On Friday 26 October 2007 8:56 am, [EMAIL PROTECTED] wrote:
Serious engineering does not imply perfect engineering, I have analyzed it
and made my tradeoffs. What you are forgetting here is that you clearly
dont understand the enire solution, So I will try to explain it again. And
if you
Hi,
I have some problems supporting translatable columns in a way that
is both efficient and comfortable for the programmer who has to write
SQL-Queries (we use iBatis)
Suppose I have a simple table that contains an id field and (amongst
others) a name field. Let's call this table foo. The names
On Sun, Oct 28, 2007 at 01:59:22AM +0200, Dennis Brakhane wrote:
I have some problems supporting translatable columns in a way that
is both efficient and comfortable for the programmer who has to write
SQL-Queries (we use iBatis)
Maybe this helps a bit:
Catalin Marinas [EMAIL PROTECTED] writes:
Is there an easy way to generate a headline from separate fragments
containing the search words and maybe separated by ...?
Hmm, the documentation for ts_headline claims it does this already:
functionts_headline/function accepts a document along
On Sat, 27 Oct 2007, Tom Lane wrote:
Catalin Marinas [EMAIL PROTECTED] writes:
Is there an easy way to generate a headline from separate fragments
containing the search words and maybe separated by ...?
Hmm, the documentation for ts_headline claims it does this already:
Hi all,
I've read everything in this subject you guys has discussed already
(including topic started by Max Zorloff) but I haven't found my answer yet.
I'm looking for hints on best configuration for my specific needs: I'm
having complied program written in C, which reads lots of data from
27 matches
Mail list logo