meta user
network profile
| bio | website | |
|---|---|---|
| location | Vienna, Austria | |
| age | 93 | |
| visits | member for | 1 year, 8 months |
| seen | 15 hours ago | |
| stats | profile views | 370 |
|
15h |
comment |
Is a composite index also good for queries on the first field? @Zoltán: It depends. For very small columns (like two integer) the index on (a,b) would make an additional index on (a) pointless. For bigger columns it may be different. Start a question if you need more details. |
|
1d |
awarded | Necromancer |
|
Jun 16 |
revised |
How to drop inheritance? added 1 characters in body |
|
Jun 16 |
revised |
How to drop inheritance? added 8 characters in body; edited tags; edited title |
|
Jun 16 |
answered | How to drop inheritance? |
|
Jun 13 |
revised |
Best practice for storing record metadata Postgres is tagged, not needed in the title redundantly. add tag. |
|
Jun 13 |
answered | Best practice for storing record metadata |
|
Jun 13 |
awarded | Nice Answer |
|
Jun 13 |
awarded | Popular Question |
|
Jun 11 |
comment |
PostgreSQL “freeze”/“unfreeze” command equivalents @Dan: Just flag it asking for the move, moderators will migrate it for you. |
|
Jun 10 |
comment |
PostgreSQL “freeze”/“unfreeze” command equivalents @Dan: Hm, I can just log in to other stackexchange sites with the same account using the stackexchange accout. |
|
Jun 10 |
comment |
PostgreSQL “freeze”/“unfreeze” command equivalents I would suggest to migrate this question to dba.SE. |
|
Jun 10 |
comment |
Mirrored tables on PostgreSQL Sure you can. But that would defeat it's purpose, wouldn't it? Since you seem to understand that metaphor: it's lake making a hard copy from a symlink in the file system. Except if you mean in the sense of a materialized view? There is a new feature for that in the upcoming version 9.3 btw. |
|
Jun 10 |
revised |
Mirrored tables on PostgreSQL typos, add tag |
|
Jun 10 |
answered | Mirrored tables on PostgreSQL |
|
Jun 7 |
revised |
Need an idea for a complex SQL question trim some noise |
|
Jun 7 |
answered | How to “analyze” a SQL query? |
|
Jun 3 |
revised |
PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf” tags |
|
Jun 2 |
revised |
Configuring PostgreSQL for read performance clarify the effect of clustering is for both alternatives |
|
Jun 2 |
comment |
How to import a text file with '|' delimited data to PostgreSQL database? For starters, to ask a serious question, you need to provide your PostgreSQL version, the full command you are using, some sample data and the table definition. |
