Andreas Kretschmer wrote:
> > I am using postgresql-8.3.7 and have recently got this error:
> >
> > org.postgresql.util.PSQLException: ERROR: row is too big: size 8168,
> > maximum size 8160
>
> Please show us your table definition.
>
> Wild guess: you have many, many columns, non-text (INT or
On Friday 05 March 2010 02.27:39 Thomas wrote:
> sigh,I didn't find a book with enough internal topics.
>
I found the official documentation very good, for everything else ask here
or (for the gory details) on -hackers. Or, of course, read the source,
Luke.
cheers
-- vbi
--
The following exp
Thanks for the response Tom. I am running postgres 8.3.7.
Yes, his is a highly simplified version, but I also didn't get the column name
right. One more attempt at that.
CREATE OR REPLACE FUNCTION delete_B(id integer)
RETURNS void AS
$BODY$
declare
Mridula Mahadevan writes:
> CREATE OR REPLACE FUNCTION delete_B(id integer)
> RETURNS void AS
> $BODY$
> declare
> vSql varchar;
> BEGIN
> delete from B where id = id;
> END;
That's a really dangero
sigh,I didn't find a book with enough internal topics.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have no idea how good pg is with select queries over 365 partitions (1
year).
no need to use a partition per day, I'm pretty sure he won't mind having
a few extra days or weeks. I'd go by month, and drop a whole month at
a time, that way there's only 12-13 partitions.
and doing this,
I have 3 tables say A, B, C
CREATE TABLE A
(
A_id integer NOT NULL,
CONSTRAINT A_pkey PRIMARY KEY (A_id)
)
;
CREATE TABLE B
(
B_id serial NOT NULL,
A_id integer NOT NULL,
CONSTRAINT B_pkey PRIMARY KEY (B_id),
CONSTRAINT fkd08b6eeeb4f3a730 FOREIGN KEY (A_id)
REFERENCES A(A_id) MATC
Hi All,
After a pg_dumpall, I'm trying to restore with psql -e template1 -f 21.bak
&>/tmp/out21.bak . I'm trying to migrate to Postgres 8.3.8.
I'm getting lots errors like this one:
"psql:21.bak:340557: ERROR: literal carriage return found in data
HINT: Use "\r" to represent carriage return.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Roger Tannous
Sent: Thursday, March 04, 2010 11:33 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Optimal database table optimization method
Hello,
I have a database table that is growing
On Thu, Mar 4, 2010 at 1:44 PM, Terry wrote:
> On Thu, Mar 4, 2010 at 11:43 AM, Terry wrote:
>> On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
>>> On 4 March 2010 17:26, Terry wrote:
I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
query that will return a
On Fri, Feb 26, 2010 at 4:52 PM, Scott Marlowe wrote:
> 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
On Thu, Mar 4, 2010 at 5:01 PM, John R Pierce wrote:
> are you running pgadmin and postgres server on the same computer, or on
> different computers?
Different computers.
>
> if different computers, is there any sort of connection tracking in between,
> such as a NAT router/gateway?
>
> 15-20 min
Lee Hachadoorian wrote:
I use the SQL editor in pgAdmin for all of my database work. The
problem I'm having is that after a period of inactivity, pgAdmin loses
the connection to the server. I'm trying to figure out how to avoid
this happening. Not being a network administrator, I'm wondering if
t
I use the SQL editor in pgAdmin for all of my database work. The
problem I'm having is that after a period of inactivity, pgAdmin loses
the connection to the server. I'm trying to figure out how to avoid
this happening. Not being a network administrator, I'm wondering if
this is related to the tcp_
Heyho!
Disclaimer: I don't have much experience with big databases, so this is
based on my understanding of the theory.
On Thursday 04 March 2010 20.32:46 Roger Tannous wrote:
> I have a database table that is growing too big (few hundred million
> rows) that needs to be optimized, but before
Hi
Thanks for the reply. Yes, I saw that "2769" is related to locales. On
the machine, I saw a new locale called "C" is installed. I am not sure
how it got installed. By default, this locale was getting selected. I
did select "English - united states" and try to install. It also failed
with the sa
Roger Tannous wrote:
Hello,
I have a database table that is growing too big (few hundred million
rows) that needs to be optimized, but before I get into partitioning
it, I thought I'd ask about suggestions.
Here is the usage:
0 . Table contains about 10 columns of length about 20 byte
On Mar 4, 2010, at 2:51 PM, Pavel Stehule wrote:
> hello
>
> 2010/3/4 Joshua Johnston :
>> Hello list!
>>
>> I am working through some i18n/l10n issues in a new application and one of
>> our possible solutions for handling date formatting is to have the dates
>> formatted by pgsql per session
hello
2010/3/4 Joshua Johnston :
> Hello list!
>
> I am working through some i18n/l10n issues in a new application and one of
> our possible solutions for handling date formatting is to have the dates
> formatted by pgsql per session. I know I Can use DateStyle to adjust date
> output, but I am
Hello list!
I am working through some i18n/l10n issues in a new application and one of our
possible solutions for handling date formatting is to have the dates formatted
by pgsql per session. I know I Can use DateStyle to adjust date output, but I
am looking for something that works like SET Da
On Thu, Mar 4, 2010 at 11:43 AM, Terry wrote:
> On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
>> On 4 March 2010 17:26, Terry wrote:
>>>
>>> I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
>>> query that will return all rows from dsclient_logs, insert two columns
>>> fr
Hello,
I have a database table that is growing too big (few hundred million rows)
that needs to be optimized, but before I get into partitioning it, I thought
I'd ask about suggestions.
Here is the usage:
0 . Table contains about 10 columns of length about 20 bytes each.
1.
INSERTS
On Wed, 2010-03-03 at 22:59 +0100, Marcin Krol wrote:
> What do you think of this? And in general: when (if?) should one
> denormalize data?
Your example shows that its quicker to put the ingredients on the table
than it is to bake a cake. I'm not sure that's an argument against
baking, nor is i
On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
> On 4 March 2010 17:26, Terry wrote:
>>
>> I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
>> query that will return all rows from dsclient_logs, insert two columns
>> from the customer table, and one column from backup_sets
On 4 March 2010 17:26, Terry wrote:
> I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
> query that will return all rows from dsclient_logs, insert two columns
> from the customer table, and one column from backup_sets. The
> relation is this:
>
> dsclient_logs.userid = dsbox
I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
query that will return all rows from dsclient_logs, insert two columns
from the customer table, and one column from backup_sets. The
relation is this:
dsclient_logs.userid = dsbox.dsbox_snum AND backup_sets.box_id =
dsbox.box_id
DimitryASuplatov wrote:
> Hello,
>
> I am using postgresql-8.3.7 and have recently got this error:
>
> org.postgresql.util.PSQLException: ERROR: row is too big: size 8168,
> maximum size 8160
Please show us your table definition.
Wild guess: you have many, many columns, non-text (INT or somet
Hello,
I am using postgresql-8.3.7 and have recently got this error:
org.postgresql.util.PSQLException: ERROR: row is too big: size 8168,
maximum size 8160
How is that possible in version 8+?
I`ve found some old version 7 manuals that suggest editing
/src/include/config.h file but I did not
This reminds me of the joke, How many MS employees does it take to
change a lightbulb? None, they just redefine dark as light.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi.
I think the following behaviour is not intuitive:
manlio=> DROP TABLE IF EXISTS foo.bar;
ERROR: schema "foo" does not exist
The statement should not fail if the schema does not exist
Thanks Manlio
-BEGIN PGP SIGNATURE-
Version: GnuP
On Thu, 2010-03-04 at 11:04 -0500, akp geek wrote:
> My RAM size is 8GB. I have set the maintenance_work_mem = 500MB this
> morning.
>
> ERROR: canceling autovacuum task with table name
>
> Thanks for the help
You likely have a lock that is conflicting with autovacuum and it
cancels itself
On 3/4/2010 10:00 AM, Greg Stark wrote:
> On Thu, Mar 4, 2010 at 2:14 PM, Justin Graf wrote:
>
>> To pretty much anyone outside MS, a sane human would think 64 bit apps
>> in SysWoW64 and 32Bit apps in System32. :'(
>>
>>
> Ah, but you all are forgetting that the "32" here is to distingu
My RAM size is 8GB. I have set the maintenance_work_mem = 500MB this
morning.
ERROR: canceling autovacuum task with table name
Thanks for the help
Regards
On Wed, Mar 3, 2010 at 4:31 PM, Igor Neyman wrote:
> What's the complete error message?
> Vacuum is using maintenance_work_mem. What
On Thu, Mar 4, 2010 at 2:14 PM, Justin Graf wrote:
> To pretty much anyone outside MS, a sane human would think 64 bit apps
> in SysWoW64 and 32Bit apps in System32. :'(
>
Ah, but you all are forgetting that the "32" here is to distinguish it
from the default odbc interface which as i recall was
On Wed, Mar 3, 2010 at 4:59 PM, Marcin Krol wrote:
> Hello everyone,
>
> I have inadvertently set off a furball on an unrelated ng on what is the
> actual cost of SQL joins. But there's no reliable conclusion. I would like
> to actually know that, that is, are JOINs truly expensive?
There's a lot
On 3/4/2010 3:51 AM, Richard Huxton wrote:
> On 04/03/10 01:35, Craig Ringer wrote:
>>
>> http://support.microsoft.com/kb/942976/en-us
>
> Classy. Even better - according to the linked page, the 64 bit version
> is in the "System32" folder - yippee!
>
> "* The 32-bit version of the Odbcad32.ex
A. Kretschmer wrote:
In response to Tom Lane :
Asher Hoskins writes:
I can't seem to get to_timestamp() or to_date() to work with quarters,
The source code says
* We ignore Q when converting to date because it is not
* normative.
*
2010/3/4 Richard Huxton :
> On 04/03/10 00:12, Niranjan Maturi (nmaturi) wrote:
>>
>> Hi
>>
>> I am trying to install Postgres 8.2 on a virtual machine that has
>> Windown 2003 SP2. The installation fails with the error "Failed to run
>> initdb: 128". I searched the archives and looks like it is a
On 4/03/2010 4:47 PM, Richard Huxton wrote:
On 03/03/10 21:59, Marcin Krol wrote:
What do you think of this? And in general: when (if?) should one
denormalize data?
As a last resort. No sooner.
The support costs of denormalising your database is such that if you can
reasonably just buy more h
> I've written a long paper covering the internals here named "Inside the
> PostgreSQL Buffer Cache" at
> http://www.westnet.com/~gsmith/content/postgresql/ if you want to know
> exactly how this is all implemented.
Greg,
That's exactly what I was looking for,
Regards,
John
--
Sent via pgsql-g
the reason you are using joins, most often is because your schema is
normalized. One way or another, de-normalisation + queries will cost you
more, than normalised tables and joins.
That's at least the short answer.
On 04/03/10 00:12, Niranjan Maturi (nmaturi) wrote:
Hi
I am trying to install Postgres 8.2 on a virtual machine that has
Windown 2003 SP2. The installation fails with the error "Failed to run
initdb: 128". I searched the archives and looks like it is a catch-all
error. But is there anything spec
On 04/03/10 01:35, Craig Ringer wrote:
Argh - a follow-up re ODBC 32 and 64 bit-ness:
http://blog.danovich.com.au/2010/02/02/odbc-settings-on-64-bit-servers/
It's way crazier than you'd ever expect. Both the 32-bit and 64-bit
versions are called "odbcad32.exe" but are in different (but not
dist
On Thu, Mar 4, 2010 at 1:54 AM, Scott Marlowe wrote:
> On Wed, Mar 3, 2010 at 6:45 PM, Greg Sabino Mullane wrote:
>>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: RIPEMD160
>>
>>
>>> It's way crazier than you'd ever expect. Both the 32-bit and 64-bit
>>> versions are called "odbcad32.exe" but ar
On 03/03/10 21:59, Marcin Krol wrote:
What do you think of this? And in general: when (if?) should one
denormalize data?
As a last resort. No sooner.
The support costs of denormalising your database is such that if you can
reasonably just buy more hardware / add caching / etc, do so.
Oh, an
45 matches
Mail list logo
