524 reputation
27
bio website mesoconcepts.com
location
age
visits member for 3 years, 2 months
seen Mar 11 at 22:04

Available for hire (ddebernardy at yahoo dot com).


Nov
24
comment Amount of memory used by postgres
@AliceEverett: that's probably a question for DBA...
Nov
24
answered Amount of memory used by postgres
Nov
15
comment Postgresql indexes in memory
@IgorRomanchenko: it can make some sense when running a cache with unlogged tables in a ramdisk — though admittedly, one might as well use memcached in that case. :-)
Sep
26
comment Get count of processed queries
Look into github.com/julmon/pg_activity or its source code.
May
20
awarded  Yearling
May
19
comment MySQL Master/Slave. Actual use of Slave Machine
Isn't master-master relying on NDB in MySQL?
May
19
comment MySQL Master/Slave. Actual use of Slave Machine
An NDB cluster is probably a terrible idea.
May
16
comment PostgreSQL group roles
This grants write perms to the tables, which isn't what OP wants. Fwiw in addition, I was thinking the same when writing my own answer, but testing revealed a PG bug (in 9.2 anyway). Running alter default privileges in schema foo grant select on tables to public; is, per docs, supposed to grant select on all tables in schema foo to public; automatically on new tables (i.e. what OP wants), but testing revealed that you still need to run that query manually (i.e. what OP is currently doing) for some reason.
May
16
comment PostgreSQL group roles
After playing around with it, it most definitely looks like there's a bug or three in Postgres...
May
3
comment InnoDB errors after having deleted “ibdata1”
Should go to DBA...
May
3
comment Can't connect to the postgres server ls: /tmp/.s.PGSQL.5432: No such file or directory
(Or the new one might not be running yet.)
May
3
comment Can't connect to the postgres server ls: /tmp/.s.PGSQL.5432: No such file or directory
Restart your Mac. The older version of Postgres (the one that's installed by OSX) might still be running.
May
2
comment Database design - People and Organisations
I'm not saying it's impossible. Merely that it's thorny. And that in practice there's very little value in doing so "properly" considering the joins, validation issues, and UI/UX involved, vs something that would actually cover 99% of cases with a conveniently well known UI, aka Outlook.
May
2
comment Database design - People and Organisations
One big example would be when you normalize the company. If you toss in a link to a screen with an edit button when you click it, you may very well end up with the secretary screw up I mention further up. One alternative, which is a convenience textfield to rename the company, amounts to the same. The last alternative is to have a dumb text field with no ties to the table at all (just like in Outlook), and to tie things back up in a subsequent (or ajax) screen if there is actual need for normalization.
May
2
answered Database design - People and Organisations
May
20
awarded  Yearling
Jul
26
answered ts_rank massively slows my query, how can I improve performance?
Jul
4
answered Postgresql row-level encryption
Jun
28
answered Best database choice for a highly scalable web ticketing system?
Jun
28
comment Optimizing query using view on EAV structure
Yeah: your example fits my description precisely: it uses the index because of the condition on a = 1. If you remove the latter, the index won't be used. The more coercive to the left-most columns, the better the result. Now, in your case, the key is to have an index that the planner can use. You're looking for, say, a weight; so an index on (name) fits; one on (item, name) won't. As for partial indexes, think of them as having an extra column (the expression) tossed in the left-most position. B-tree indexes are traversed left to right.