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 subscrip
anting to go over to plpythonu or whatnot (whose description
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-hacker
sable to do this via 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
Soci
other than ALTER TABLE -- 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
gument to ColId
production, which goes unparsed. Shame on me for using such an old
version [ 8.2 ], but hey, it works.
James Robinson
Socialserve.com
g periods are eroded to their relname portion, and that > 2
dots == death:
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@p
ction "track_t1_changes" line 2 at if
ROLLBACK
8.2.bug.sql
Description: Binary data
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
rivial unfortunately.
I hate to say it, but would mysql / myisam not work well for points
1-5 ? I have not idea about it and 'fast as hell' -- not ever run it
in production for anything. 6 + 7 could possibly be done atop mysql
using a 3-tier model.
James Robinson
Socialserve.com
example, I 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
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
---(e
iness afoot perhaps
hardware-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 g
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 t
ind 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
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
ostgresMain ()
#16 0x0816ffa9 in ServerLoop ()
#17 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
y mounting issue
here. args: 'postgres: 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 t
this table.
Finally, the only possibly potentially interesting event database-
wise happened on Wed. Nov. 23'rd -- we SIGHUP'd the postmaster to
have it learn a higher value for work_mem (10240, up from default of
1024). But the hourly crons went great for the subsequent two days.
m
yet, then it just fails as normal.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
e to run
inside PG. Ugly savepoint handling and all.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
has seemed to suit us just fine.
----
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
ELSIF and ELSEIF as legal 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
hanks.
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
until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
COMMIT
Many thanks in advance,
James
pets.sql
Description: Bina
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]
atus = 8
Foreign-key constraints:
"unit_building_fkey" FOREIGN KEY (building) REFERENCES building(id)
"unit_city_fkey" FOREIGN KEY (city) REFERENCES housingcity(id)
"unit_leadpaintunit_fkey" FOREIGN KEY (leadpaintunit) REFERENCES
leadpaintun
it(id)
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
tarting up
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
exactly two tables
(t3 and t4), not the t1, 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])
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
ent code 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
naged transactions *by the middleware container*, and, if the
middleware container is configured to cache prepared statements between
transactions, then it will expect them to live well beyond their
initial explicitly-managed transaction.
James Robinson
Socialserv
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
hive transaction log protocol. If my proposed
usage 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-nom
ts
this
wrong. pg_autovacuum is another good step in this direction.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
e 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: sub
() 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
se when reading from TCP socket
instead of UNIX domain? Pulling down code ...
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECT
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
og expert managed schema patch would have
been greatly appreciated 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
postgres. 'Cause its our 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
40 matches
Mail list logo
