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 alter column SET STATISTICS ;
>
> An
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
c
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, e
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.
>
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 w
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 sys
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 archiv
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 els
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 St
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 ign
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 g
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
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 ti
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, h
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 name
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:
http://salaam.homeunix.com
"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:
ts_headline accepts a document along
with a q
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:
ts_headline
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
c
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 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 wai
26 matches
Mail list logo
