Hi,
I'm writing a book on SQL, with a short section about query tuning and
automatic optimization advisors for different RDBMS platforms, for
instance, extensions to EXPLAIN that recommend new indexes based on
workload and query plans.
When I searched for a solution for PostgreSQL, Gurjee
Bruce Momjian wrote:
Hiroshi Inoue wrote:
Bruce Momjian wrote:
Where are we on this issue?
Oops I forgot it completely.
I have a little improved version and would post it tonight.
Ah, very good. Thanks.
Attached is an improved version.
regards,
Hiroshi Inoue
? formatting.patch
? pg_local
On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane wrote:
> Terry writes:
>> I am somewhat confused. My app is detecting it as a serial data type
>> but describing the table shows that its an integer. What am I
>> missing?
>
>> dssystem=# \d clients_event_log
>> Ta
Terry writes:
> I am somewhat confused. My app is detecting it as a serial data type
> but describing the table shows that its an integer. What am I
> missing?
> dssystem=# \d clients_event_log
>Table "public.clients_event_log"
> Column |
On Fri, Feb 26, 2010 at 3:16 PM, Scott Marlowe wrote:
> On Fri, Feb 26, 2010 at 1:46 PM, Terry wrote:
>> On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote:
>>> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe
>>> wrote:
On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote:
> Hello,
>
> I h
In one of my new roles, one of my projects has been to setup a proof of
concept solution using PostgreSQL, which one emphasis being on performance
monitoring during testing / dev ...
We are mainly a nagios / cacti environment, and I came across:
http://forums.cacti.net/about23300.html&hi
On Fri, Feb 26, 2010 at 1:46 PM, Terry wrote:
> On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote:
>> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe
>> wrote:
>>> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote:
Hello,
I have an application that is doing something stupid in that it is
On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote:
> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe
> wrote:
>> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote:
>>> Hello,
>>>
>>> I have an application that is doing something stupid in that it is
>>> tacking on its own order clause at the end of the s
Thom Brown escribió:
> On 26 February 2010 14:33, Raymond O'Donnell wrote:
> > On 26/02/2010 12:15, Thom Brown wrote:
> >> On 26 February 2010 12:02, Anton Maksimenkov wrote:
> I'm also curious to know why there's an underflow error instead of
> overflow. And in fact, even if a 19 digit phone n
On Fri, Feb 26, 2010 at 17:24, Igor Neyman wrote:
> Hello all,
>
> I found this conversation in mailing lists archives:
>
> http://archives.postgresql.org/pgsql-general/2007-11/msg01669.php
>
> OP in this conversation exactly describes my current problem (thread limit
> for postmaster running on W
Hello all,
I found this conversation in mailing lists archives:
http://archives.postgresql.org/pgsql-general/2007-11/msg01669.php
OP in this conversation exactly describes my current problem (thread
limit for postmaster running on Windows).
I'm running 8.2.5, which predates this conversati
On 26 February 2010 14:33, Raymond O'Donnell wrote:
> On 26/02/2010 12:15, Thom Brown wrote:
>> On 26 February 2010 12:02, Anton Maksimenkov wrote:
>>> Hi.
>>>
>>> I have a simple function.
>>> CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
>>> in_phone VARCHAR
>>> ) RETURNS BIGINT
>>> --
On 26/02/2010 12:15, Thom Brown wrote:
> On 26 February 2010 12:02, Anton Maksimenkov wrote:
>> Hi.
>>
>> I have a simple function.
>> CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
>> in_phone VARCHAR
>> ) RETURNS BIGINT
>> -- IMMUTABLE
>> AS $$
>> DECLARE
>> t_extent_len BIGINT;
>> t_p
On Thu, 25 Feb 2010 11:41:58 +0100
Pavel Stehule wrote:
> use --enable-assert configure flag?
>
> you can use memory in bad context. So you are alloc good memory,
> but when you leave function, then complete memory context is
> freeed and you can have a problem.
Meanwhile I experienced some new
On 26 February 2010 12:02, Anton Maksimenkov wrote:
> Hi.
>
> I have a simple function.
> CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
> in_phone VARCHAR
> ) RETURNS BIGINT
> -- IMMUTABLE
> AS $$
> DECLARE
> t_extent_len BIGINT;
> t_phone_18 BIGINT;
> t_multiplier BIGINT;
> BEGIN
>
>
Hi.
I have a simple function.
CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
in_phone VARCHAR
) RETURNS BIGINT
-- IMMUTABLE
AS $$
DECLARE
t_extent_len BIGINT;
t_phone_18 BIGINT;
t_multiplier BIGINT;
BEGIN
IF in_phone IS NULL OR in_phone = '' THEN
RAISE EXCEPTION 'in_phone[%] I
Albe Laurenz wrote:
To find out what PostgreSQL stuff you have installed (provided
you installed it as RPM and did not compile it from source),
you can run
rpm -qa | grep postgres
Some other useful tricks to know here; most commands take "--version":
$ initdb --version
initdb (PostgreSQL) 8
Albe Laurenz wrote:
If you care about the data in the 7.3 data directory, you will
have to migrate it: start a 7.3 server, export with 8.3's
pg_dumpall, run 8.3's initdb, import the dump.
and thats not that easy with Redhat/Centos/Fedora/etc RPM installs, as
installing 8.x from RPM sources
Mary Y Wang wrote:
> I got this error:
> "-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start
> server starting
> -bash-2.05b$ FATAL: database files are incompatible with server
> DETAIL: The data directory was initialized by PostgreSQL
> version 7.3, which is not compatible with this version 8.3.8."
19 matches
Mail list logo
