7,641 reputation
1558
bio website ledgersmbdev.blogspot.com
location Jakarta, Indonesia
age 38
visits member for 2 years, 1 month
seen Oct 19 at 1:37

I am the most active developer on LedgerSMB, which accounts for most of my consulting and freelance work. I also offer PostgreSQL-related consulting services and more.

I also am a co-founder of Efficito which offers LedgerSMB ERP hosting for small to midsized businesses. Efficito: Robust, flexible, and open.

Finally I am a principal consultant for 2ndQuadrant and offer PostgreSQL consulting services throughout South-East Asia.


Sep
14
answered Disaster Recovery for PostgreSQL 9.0
Sep
13
answered pg_dump from 9.2 to 8.4
Sep
12
answered Writing with multiple psql processes to database seems to damage data
Sep
12
answered Finding by ID in postgresql very slow on big table
Sep
12
comment Text-based interface for PostgreSQL?
you can do this with psql, actually @TinyProton. See the \d commands. Use \? for a list.
Sep
12
comment How do I efficiently get “the most recent corresponding row”?
I dont think it needs to be exact, but worried about the problem being lost in the allegory. Something a little closer would be helpful. The issue is that with pricing, the price at a certain day is likely to be a default, and consequently you wouldn't use it for reporting only as a default for transaction entry, so your interesting queries are typically only a few rows at a time.
Sep
10
revised How do I efficiently get “the most recent corresponding row”?
added 1802 characters in body
Sep
10
comment How do I efficiently get “the most recent corresponding row”?
Good point. Re-reading though I spot some real practical deficiencies with the proposed data but I can't tell if it is just a contrived example. As a contrived example, I can't tell what is missing. Maybe an update to point this out would be in order too.
Sep
10
answered How do I efficiently get “the most recent corresponding row”?
Sep
9
answered PostgreSQL Hot Standby
Sep
8
comment Which schema is better for a shopping project?
Also regarding the classic way, I think your problem is that you end up with a lot of the problems of EAV modelling. This can be used, but it means that queries like "show me all hard drives with a capacity of 500GB, using an SATA interface, and with a speed of 7200 RPM" becomes an amazingly complex query which does not scale.
Sep
8
comment Which schema is better for a shopping project?
@burakemre, what you lose with JSON is an ability to do real type enforcement on a db schema level, so you can't be sure that all the required fields are filled in on the db level.
Sep
7
answered Which schema is better for a shopping project?
Sep
5
answered Scaling of PostGIS vs MySQL cos/sin calculations
Sep
4
answered Postgresql vs MySQL - Which is better for join queries & writing data(inserts)
Sep
1
awarded  Revival
Sep
1
answered Truncate table is taking too long in PostgreSQL
Sep
1
answered Performance difference between MySQL and PostgreSQL for the same schema/queries
Aug
31
answered When using a master plus multiple slaves, how do I change over from one server to a brand new one with minimal downtime?
Aug
30
answered Postgres caching and bytea