butt on the
line hosting our client's data.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
to solve at least the 'stay out of other
user's crud by default' issues.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
code ...
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list
() does a lot of little itty bitty writes to the
frontend filedescriptor.
What do you get if you comment out that block in child.c, around line
372? Either a faster system or a non-working one?
James Robinson
Socialserve.com
---(end of broadcast
the CompleteCommandResponse
handler method ends with a call to pool_write_and_flush(), and
you've pretty much gotta get a CompleteCommand message
trailing all of those rows.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: subscribe
to manipulate temporary tables.
Quite spiffy, reducing the amount of surprise encountered by postgres
neophytes.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org
step in this direction.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
is flawed, then negative kudos to my puny mind.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
On Jun 10, 2004, at 10:30 AM, [EMAIL PROTECTED] wrote:
Prior to lazy vacuum, this was impossible.
Do you know for sure that lazy vacuum and/or autovacuum does
not indeed solve / alleviate the symptoms of the general problem
of very high rate table updates?
Back to lurking!
James Robinson
in the
backend could be written , say, somewhere in the internals document
around the coding conventions chapter:
http://developer.postgresql.org/docs/postgres/source.html
I myself don't have a clue, not being a backend hacker, so I'll just
slink back to my cave.
James Robinson
Socialserve.com
implementation?
Quotas per user per tablespace, assuming 7.5 gets tablespaces.
User quotas would make postgres on a shared university box much more
pleasant.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
, t2, t3 cartesian product joined with t4.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
LOG: database system is ready
We were back online within minutes of the interruption w/o any data
loss.
So, I raise my glass to you! Thank you!
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
casts the literal int4 to an int8, making the int8
column index useable.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
)
unit_zipcode_fkey FOREIGN KEY (zipcode) REFERENCES zipcode(id)
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
Patch applied, fixes beta4 for the query with our data. Many thanks
again!
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
COMMIT
Many thanks in advance,
James
pets.sql
Description: Binary data
James Robinson
Socialserve.com
---(end of broadcast)---
TIP
.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
spellings of the keyword. This seems a
bit ugly but I can't think of any really good objections.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
seemed to suit us just fine.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
fails as normal.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
a higher value for work_mem (10240, up from default of
1024). But the hourly crons went great for the subsequent two days.
maintenance_work_mem is still at the default of 16384.
Many thanks in advance!
James
James Robinson
Socialserve.com
---(end of broadcast
: postgres social [local] VACUUM waiting'
28861 -- production servicing backend, now back in idle state. [ not
in tx idle by regular idle ].
On Nov 28, 2005, at 11:09 AM, Tom Lane wrote:
James Robinson [EMAIL PROTECTED] writes:
Comparing the logs further with when it did complete, it seems that
one
0x08170de9 in PostmasterMain ()
#18 0x0813e5e5 in main ()
(gdb) quit
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
to remote?
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
that additional buffering a damnable offense?
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Nov 28, 2005, at 1:46 PM, Tom Lane wrote:
James Robinson [EMAIL PROTECTED] writes:
backtrace of the sshd doesn't look good:
Stripped executable :-( ... you won't get much info there. What of
the client at the far end of the ssh connection? You should probably
assume that the blockage
-wise?
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list
savepoint handling and all.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
I'm interested in poking though and taking a shot at getting my feet
wet with pl/python. I see the file is copyright Andrew Bosma -- is he
still around perhance? Is anyone currently the 'owner' ?
James Robinson
Socialserve.com
---(end of broadcast
see that plpython functions cannot be declared
to return void. That can't be too tough to remedy. Implementing the
DBI 2.0 API interface to SPI can wait another day.
On Feb 24, 2006, at 11:08 PM, Joshua D. Drake wrote:
James Robinson wrote:
I'm interested in poking though and taking a shot
it
in production for anything. 6 + 7 could possibly be done atop mysql
using a 3-tier model.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe
-- such as DISABLE TRIGGER foo
ON tbar ?
Thanks!
James Robinson
Socialserve.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
: Binary data
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
:
social=# listen foo.bar.blat.blam;
ERROR: improper qualified name (too many dotted names):
foo.bar.blat.blam
Thanks!
James Robinson
Socialserve.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
production, which goes unparsed. Shame on me for using such an old
version [ 8.2 ], but hey, it works.
James Robinson
Socialserve.com
of rows are as dicts).
Is there something in the internals which inherently prevent this? Or
am I fool and it already exists?
Not having to defer to EXECUTE would be attractive.
James Robinson
Socialserve.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
to
their work.
But it little bit digging in the mailing list archives should turn
them up.
Many thanks, Florian, we'll be checking that out.
James
James Robinson
Socialserve.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
multiple clusters
instead of a single cluster, tweaking the processor affinity of each
postmaster accordingly, trying to ensure each cluster's shared memory
segments and buffer cache pools remain local for the resulting backends?
Thanks!
James Robinson
Socialserve.com
--
Sent via
39 matches
Mail list logo