On Fri, Oct 31, 2008 at 06:57:25PM -0400, Eric Schwarzenbach wrote:
>
> My problem with GEQO using a random number generator is that
> non-deterministic behavior is really hard to debug, and problems can go
> undiagnosed for ages. Frankly I would rather something fail all the
> time, than it work
Tomasz Ostrowski wrote:
This is wrong. RAID5 is slower than RAID1.
You should go for RAID1+0 for fast and reliable storage. Or RAID0 for
even faster but unreliable.
I did not find a clear statement about this. I agree that RAID10 would
be better than RAID5, but in some situations RAID5 at lea
Hello Tom,
During configure I find the error in config.log file
checking for flags to link embedded Perl... Can't locate ExtUtils/Embed.pm
in @INC (@INC contains: /usr/lib/perl5/5.10.0/i386-linux-thread-multi
/usr/lib/perl5/5.10.0
/usr/lib/perl5/site_perl/5.10.0/i386-linux-thread-multi
/usr/li
Jonathan Guthrie wrote:
> The thing is, the C++ code does this
>
> BEGIN transaction 1
> INSERT project
> COMMIT
>
> BEGIN transaction 2
> SET permissions
> COMMIT
>
> or, at least, it's supposed to.
OK, and we know that if it is doing what it is supposed to, transaction
2 /must/ see the chang
Scott Ribe wrote:
'make' is prefixed by /Developer/usr/bin/.
The question is *why* the location is nonstandard.
Starting with Xcode 3, all the developer tools get installed under the
Developer directory, in order to allow one to easily have multiple versions
of Xcode installed alongside each o
>> 'make' is prefixed by /Developer/usr/bin/.
>
> The question is *why* the location is nonstandard.
Starting with Xcode 3, all the developer tools get installed under the
Developer directory, in order to allow one to easily have multiple versions
of Xcode installed alongside each other. The ques
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane escribió:
>> There already is a \dC command in psql, which has nice enough output
>> format but doesn't provide any way to select a subset of the table.
>> Maybe we should just agree that its argument is a pattern for the
>> castsource type's n
Eric Schwarzenbach wrote:
> This is in a sense a followup to my post with subject "Wildly erratic
> query performance". The more I think about it the only thing that makes
> sense of my results is if the query planner really WAS choosing my join
> order truly randomly each time. I went digging into
This should be a dumb question:
--with-perl
I don't see that I have to do this in order to load pl/perl as a
function/trigger language option. So I should assume that this will
compile pl/perl in rather than having it available as a loadable
function. Nice for optimizations?
I'm assuming
Tom Lane wrote:
Tom Allison <[EMAIL PROTECTED]> writes:
I tried getting a source install on my mac book yesterday and today.
It's not a normal *nix installation. The location of the files are all
non-standard.
'make' is prefixed by /Developer/usr/bin/.
The question is *why* the location is no
On Nov 4, 2008, at 4:14 PM, Tom Lane wrote:
Tom Allison <[EMAIL PROTECTED]> writes:
I tried getting a source install on my mac book yesterday and today.
It's not a normal *nix installation. The location of the files are
all
non-standard.
'make' is prefixed by /Developer/usr/bin/.
The que
On Tue, Nov 4, 2008 at 6:32 PM, Eduardo Arévalo <[EMAIL PROTECTED]> wrote:
> hola quiero crear una base que soporte caracteres en español y le doy este
> comando pero no crea la base sino me manda este error:
>
> -bash-3.2$ ./createdb --encoding=LATIN1 sig_spa_prueba
> Password:
> createdb: databas
hola quiero crear una base que soporte caracteres en español y le doy este
comando pero no crea la base sino me manda este error:
-bash-3.2$ ./createdb --encoding=LATIN1 sig_spa_prueba
Password:
createdb: database creation failed: ERROR: encoding LATIN1 does not match
server's locale en_US.UTF-8
On Tue, Nov 4, 2008 at 12:46 PM, Webb Sprague <[EMAIL PROTECTED]> wrote:
>> Or do it with simple combo boxes if you
>> want to limit the users to crippled queries.)
>
> I want to limit my users to *half* crippled queries -- arbitrary
> column lists, where clauses, group by lists, and sort by lists.
On Nov 4, 2008, at 1:02 PM, Tom Allison wrote:
I tried getting a source install on my mac book yesterday and today.
It's not a normal *nix installation. The location of the files
are all
non-standard.
'make' is prefixed by /Developer/usr/bin/.
It's in /usr/bin/make on my OS X box (as well
Tom Allison <[EMAIL PROTECTED]> writes:
> I tried getting a source install on my mac book yesterday and today.
> It's not a normal *nix installation. The location of the files are all
> non-standard.
> 'make' is prefixed by /Developer/usr/bin/.
The question is *why* the location is nonstandard.
Jonathan Guthrie <[EMAIL PROTECTED]> writes:
> ... or, at least, it's supposed to. Those two operations are not supposed
> to overlap at all even if they're on two different connections. I
> thought I had verified this by looking at the log file. I mean, I can
> look at the log file and see thin
Francisco Figueiredo Jr. wrote:
On Tue, Nov 4, 2008 at 8:21 AM, Tom Allison <[EMAIL PROTECTED]> wrote:
Grzegorz Jaśkiewicz wrote:
I feel good about control here, and I certainly don't have any problems.
So, please don't whine :)
Especially since I want to run cvs head, and be able to actually u
On Wed, 2008-11-05 at 04:40 +0900, Craig Ringer wrote:
> The point is that if your initial create and the setting of the initial
> permissions must succeed or fail together, they MUST be done within a
> single transaction. That is, in fact, the fundamental point of database
> transactions.
I under
On Nov 4, 2008, at 11:46 AM, Webb Sprague wrote:
Or do it with simple combo boxes if you
want to limit the users to crippled queries.)
I want to limit my users to *half* crippled queries -- arbitrary
column lists, where clauses, group by lists, and sort by lists. I
want to make sure that the
Andreas Kretschmer replied:
> I wrote:
> > How about doing:
> >
> > SELECT justify_interval(90061 * '1 second'::INTERVAL);
>
> Nice, didn't know this function.
Yup, PG does everything! Not sure when I discovered it; also not sure
if I've ever had to use it in anger before. I am, however, sli
Sam Mason <[EMAIL PROTECTED]> schrieb:
> On Tue, Nov 04, 2008 at 05:06:37PM +, Joao Ferreira gmail wrote:
> > I've been searching the docs on a simple way to convert a time
> > _duration_ in seconds to the format dd:hh:mm:ss, but I can't find it.
> >
> > 90061 --> 1d 1h 1m 1s
> >
> > (90061=
> Or do it with simple combo boxes if you
> want to limit the users to crippled queries.)
I want to limit my users to *half* crippled queries -- arbitrary
column lists, where clauses, group by lists, and sort by lists. I
want to make sure that they aren't doing any data modifications nested
insid
Jonathan Guthrie wrote:
> It's possible, likely even. We use a connection pool to manage
> connections to the database and they're doled out as the system sees
> fit. However, at some point every update has to finish such that any
> view of the database will see that update as finished, right?
On Nov 4, 2008, at 11:12 AM, Webb Sprague wrote:
If they're that smart, they're smart enough to deal with SQL, and
likely to be frustrated by a like-sql-but-not command language or
a GUI query designer.
Instead, create a user that only has enough access to read data (and
maybe create temporary
On Tue, Nov 04, 2008 at 11:12:05AM -0800, Webb Sprague wrote:
> > If they're that smart, they're smart enough to deal with SQL, and
> > likely to be frustrated by a like-sql-but-not command language or
> > a GUI query designer.
> >
> > Instead, create a user that only has enough access to read data
On Tue, Nov 4, 2008 at 2:12 PM, Webb Sprague <[EMAIL PROTECTED]> wrote:
> Can't do that. (Or I wouldn't have asked the question.) Need a WWW
> interface, period.
A WWW interface doesn't preclude the suggestion of simply relying on
permissions to maintain safety and providing what amounts to a q
> If they're that smart, they're smart enough to deal with SQL, and
> likely to be frustrated by a like-sql-but-not command language or
> a GUI query designer.
>
> Instead, create a user that only has enough access to read data (and
> maybe create temporary tables) and use that user to give them
>
Jonathan Guthrie wrote:
> On Tue, 2008-11-04 at 07:49 +, Richard Huxton wrote:
>> Jonathan Guthrie wrote:
>>> When I create a project, entries in the project table and the resource
>>> table are created in a single function. Then, separate functions are
>>> called to set the owner's access to
On Tue, Nov 4, 2008 at 11:18 AM, Jonathan Guthrie
<[EMAIL PROTECTED]> wrote:
> On Tue, 2008-11-04 at 07:49 +, Richard Huxton wrote:
>> Jonathan Guthrie wrote:
>> > When I create a project, entries in the project table and the resource
>> > table are created in a single function. Then, separate
On Tue, 2008-11-04 at 07:49 +, Richard Huxton wrote:
> Jonathan Guthrie wrote:
> > When I create a project, entries in the project table and the resource
> > table are created in a single function. Then, separate functions are
> > called to set the owner's access to the new project. These oth
On Tue, Nov 4, 2008 at 10:59 AM, Steve Atkins <[EMAIL PROTECTED]> wrote:
>
> On Nov 4, 2008, at 9:21 AM, Webb Sprague wrote:
>
>> Hi all,
>>
>> I am writing an application that allows users to analyze demographic
>> and economic data, and I would like the users to be able to pick
>> columns, transf
am Tue, dem 04.11.2008, um 17:06:37 + mailte Joao Ferreira gmail folgendes:
> Hello,
>
> I've been searching the docs on a simple way to convert a time
> _duration_ in seconds to the format dd:hh:mm:ss, but I can't find it.
>
> 90061 --> 1d 1h 1m 1s
>
> (90061=24*3600+3600+60+1)
>
> any id
On Tue, Nov 04, 2008 at 05:06:37PM +, Joao Ferreira gmail wrote:
> I've been searching the docs on a simple way to convert a time
> _duration_ in seconds to the format dd:hh:mm:ss, but I can't find it.
>
> 90061 --> 1d 1h 1m 1s
>
> (90061=24*3600+3600+60+1)
>
> any ideas ?
>
> I've been usi
On Tue, Nov 4, 2008 at 8:21 AM, Tom Allison <[EMAIL PROTECTED]> wrote:
> Grzegorz Jaśkiewicz wrote:
>>
>> I feel good about control here, and I certainly don't have any problems.
>> So, please don't whine :)
>> Especially since I want to run cvs head, and be able to actually update it
>> from cvs w
On Nov 4, 2008, at 9:21 AM, Webb Sprague wrote:
Hi all,
I am writing an application that allows users to analyze demographic
and economic data, and I would like the users to be able to pick
columns, transform columns with functions (economists take the
logarithm of everything), and write custo
On Tue, Nov 4, 2008 at 10:53 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Tue, Nov 4, 2008 at 10:06 AM, Joao Ferreira gmail
> <[EMAIL PROTECTED]> wrote:
>> Hello,
>>
>> I've been searching the docs on a simple way to convert a time
>> _duration_ in seconds to the format dd:hh:mm:ss, but I can'
On Tue, Nov 4, 2008 at 10:06 AM, Joao Ferreira gmail
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've been searching the docs on a simple way to convert a time
> _duration_ in seconds to the format dd:hh:mm:ss, but I can't find it.
>
> 90061 --> 1d 1h 1m 1s
>
> (90061=24*3600+3600+60+1)
select number*
"praveen" <[EMAIL PROTECTED]> writes:
> but when I execute command "make " that time I got following errors.
> make[3]: *** [plperl.o] Error 1
> make[3]: Leaving directory `/home/postgres/postgresql-8.1.5/src/pl/plperl'
> make[2]: *** [all] Error 1
> make[2]: Leaving directory `/home/postgre
Hi all,
I am writing an application that allows users to analyze demographic
and economic data, and I would like the users to be able to pick
columns, transform columns with functions (economists take the
logarithm of everything), and write customized WHERE and GROUP-BY
clauses. This is kind of li
Kris Jurka wrote:
On Mon, 3 Nov 2008, Jason Long wrote:
*Would someone please comment on the status of setQueryTimeout in the
JDBC driver? Is there any workaround if this is still not implemented?*
setQueryTimeout is not implemented, the workaround is to manually
issue SET statement_time
Hello,
I've been searching the docs on a simple way to convert a time
_duration_ in seconds to the format dd:hh:mm:ss, but I can't find it.
90061 --> 1d 1h 1m 1s
(90061=24*3600+3600+60+1)
any ideas ?
I've been using to_char and to_timestamp to format dates/timestamps...
but this is diferent...
My problem with GEQO using a random number generator is that
non-deterministic behavior is really hard to debug, and problems can go
undiagnosed for ages. Frankly I would rather something fail all the
time, than it work most of the time and fail just now and then. Never
getting a good plan for a q
This is in a sense a followup to my post with subject "Wildly erratic
query performance". The more I think about it the only thing that makes
sense of my results is if the query planner really WAS choosing my join
order truly randomly each time. I went digging into the manual and
Section 49.3.1. "G
On Fri, 2008-10-31 at 17:31 +0200, Devrim GÜNDÜZ wrote:
> Hi,
>
Have you considered installing directlly from CPAN ?
# perl -MCPAN -e 'install DBD::Pg;'
joao
> On Fri, 2008-10-31 at 09:20 -0400, Kevin Murphy wrote:
>
> > My life would be complete if it offered perl-DBD-Pg for CentOS 5!
>
>
On Tue, Nov 04, 2008 at 05:55:51PM +0530, sathiya psql wrote:
> Dear All,
>
>
> Recently i have released the next version of the epqa. which is a very
> useful tool for, gives input for optimizing psql queries, and fine tuning
> it.
Generally, it's good to send announcements like this to
pgsql-
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> It seems that gin creation is triggering something nasty in the
> server that depends on previous history of the server.
Can you put together a self-contained test case that illustrates this?
regards, tom lane
--
Sent v
It seems that gin creation is triggering something nasty in the
server that depends on previous history of the server.
If I vacuum full than drop the index and recreate it even with
maintenance_work_mem='200MB' index creation may take forever.
Stopping the execution may make vacuuming very slow or
On Tue, Nov 4, 2008 at 9:57 AM, Lennin Caro <[EMAIL PROTECTED]> wrote:
>> Hi all,
>>
>> I'm re-writing some functions and migrating bussines
>> logic from a
>> client application to PostgreSQL.
>>
>> I expected something like this to work, but it doesn't:
>>
>> -- simple table
>> CREATE TABLE somet
Hello ,
I am trying to install postgresql-8.1.5 and postgresql-8.2.5 in linux
(Linux
version 2.6.25-14.fc9.i686 (mockbuild@) (gcc version 4.3.0 20080428 (Red
Hat
4.3.0-8) (GCC) ) #1 SMP Thu May 1 06:28:41 EDT 2008).but during compilation
it is showing following error.
I configure with follow
Yes, 'warm standby' was what I intended to write. This must have been
some kind of wishful thinking. ;)
But I'd really appreciate 'hot standby' in a future version of postgres.
Marc
Merlin Moncure wrote:
> On Tue, Nov 4, 2008 at 5:50 AM, Marc Schablewski <[EMAIL PROTECTED]> wrote:
>
>> Hi,
>>
Hello ,
I am trying to install postgresql-8.1.5 and postgresql-8.2.5 in linux (Linux
version 2.6.25-14.fc9.i686 (mockbuild@) (gcc version 4.3.0 20080428 (Red Hat
4.3.0-8) (GCC) ) #1 SMP Thu May 1 06:28:41 EDT 2008).but during compilation
it is showing following error.
make[3]: *** [plperl.o]
Ah, ok. I somehow missed the first line of the message an the rest of it
left the impression that "something" must be wrong with replication.
I guess one of my colleagues might have shut down the database by
accident and forgot to tell me.
Anyway, thanks for your reply.
Marc
Alvaro Herrera wro
Marc Schablewski <[EMAIL PROTECTED]> writes:
> ... When looking for a reason why the WAL weren't shipped, we found
> the following error message:
> 2008-10-31 17:07:52 CET 9162LOG: received smart shutdown request
> 2008-10-31 17:07:52 CET 9178FATAL: could not restore file
> "00010086
On Tue, Nov 4, 2008 at 5:50 AM, Marc Schablewski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> we are running a PostgreSQL 8.3.3 on a Linux box (SuSE 10.3, 2.6.22
> kernel) as a hot standby. After some maintenances work the WAL files
I'm assuming you meant 'warm standby'...hot standby servers can be
served
Hi all!
I have a problem. I have a field with type: bigint[], and I create a GIN
index on it but don't use the index when i use '=any'.
When I try it with '<@' operator, then use index. I don't understand why
doesn't work with '=any'?
Does anybody knows why doesn't work it?
--
Sent via pgsql-
Marc Schablewski wrote:
> Hi,
>
> we are running a PostgreSQL 8.3.3 on a Linux box (SuSE 10.3, 2.6.22
> kernel) as a hot standby. After some maintenances work the WAL files
> couldn't be shipped to that system (which had nothing to do with
> postgres, as we found out later). The problem was not no
Sure , i 'll try with our database log
Regards
sathish
On Tue, Nov 4, 2008 at 5:55 PM, sathiya psql <[EMAIL PROTECTED]> wrote:
> Dear All,
>
>
> Recently i have released the next version of the epqa. which is a very
> useful tool for, gives input for optimizing psql queries, and fine tuning
> i
> Hi all,
>
> I'm re-writing some functions and migrating bussines
> logic from a
> client application to PostgreSQL.
>
> I expected something like this to work, but it doesn't:
>
> -- simple table
> CREATE TABLE sometable (
>id SERIAL PRIMARY KEY,
>text1 text,
>text2 text
> );
>
>
On Tue, Nov 4, 2008 at 2:38 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Diego Schulz" <[EMAIL PROTECTED]> writes:
>> On Mon, Nov 3, 2008 at 10:24 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
>>> Just curious - what have you got against currval()? It seems to me that
>>> it would make your life e
Dear All,
Recently i have released the next version of the epqa. which is a very
useful tool for, gives input for optimizing psql queries, and fine tuning
it.
epqa is tool similar like, pqa. But designed and implemented to parse log
files which is in GB's. Report is similar like that.
More inf
On 4 nov 2008, at 11.21, Tom Allison wrote:
I tried getting a source install on my mac book yesterday and today.
It's not a normal *nix installation. The location of the files are
all non-standard.
'make' is prefixed by /Developer/usr/bin/.
That's not right. It should definately live in /
On 2008-10-31 09:01, Christian Schröder wrote:
> We will now move the database to a raid5
> (which should be faster than the raid1)
This is wrong. RAID5 is slower than RAID1.
You should go for RAID1+0 for fast and reliable storage. Or RAID0 for
even faster but unreliable.
Regards
Tometzky
--
.
On Tue, Nov 4, 2008 at 10:36 AM, Yiannos Pericleous <[EMAIL PROTECTED]> wrote:
> hi all,
>
> i've created a filesystem that lets you view databases, schemas and tables
> of pg server as regular directories, and records as files.
>
> it is still in its infancy, though.
>
> more info at http://yiannn
Hi,
we are running a PostgreSQL 8.3.3 on a Linux box (SuSE 10.3, 2.6.22
kernel) as a hot standby. After some maintenances work the WAL files
couldn't be shipped to that system (which had nothing to do with
postgres, as we found out later). The problem was not noticed for about
a week. When looking
Grzegorz Jaśkiewicz wrote:
I feel good about control here, and I certainly don't have any problems.
So, please don't whine :)
Especially since I want to run cvs head, and be able to actually update
it from cvs when I want to, that's the only choice. Postgresql is so
easy to get from sources, co
hi all,
i've created a filesystem that lets you view databases, schemas and tables
of pg server as regular directories, and records as files.
it is still in its infancy, though.
more info at http://yiannnos.com/dumbofs
cheers,
yiannis
--
Sent via pgsql-general mailing list (pgsql-general@pos
Hello,
we have a table where is a column with language ISO code like en,
de, ...
How can i build the index, depending on this languagecode?
>From the manual: to_tsvector([ config regconfig , ] document text)
Where is documented what "config regconfig" can be?
Thanks
Andreas
--
Sent via pgsql-
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Thom Brown
> Sent: Tuesday, November 04, 2008 1:45 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Best memory/planner settings for Postgres
>
> We've got a dedicated database
We've got a dedicated database server running PostgresSQL 8.0.9 (yes,
I know it needs upgrading), but I've noticed it looks criminally
under-configured.
Basically it's running on a server with 2 dual-core Intel Xeon 2.33
Ghz processors and 4Gb memory, but has the following settings in
postgresql.c
70 matches
Mail list logo
