(psql sessions).
postgresql version 8.0.2 on linux debian sarge.
best regards,
depesz
--
hubert lubaczewski
Network Operations Center
eo Networks Sp. z o.o.
signature.asc
Description: Digital signature
On Sat, Jun 04, 2005 at 07:17:17PM +0800, Christopher Kings-Lynne wrote:
Without reading too hard, I suggest having a quick look at contrib/ltree
module in the PostgreSQL distribution. It may or may not help you.
acr_cache doesn't care about trees. and - since i have acr_cache - i
dont have
On Sat, Jun 04, 2005 at 01:18:04PM +0200, PFC wrote:
Then write your query as :
select advert_id from acr_cache where category_id = ? and region_id = ?
order by category_id, region_id, XXX limit 20;
this is great idea - i'll check it out definitelly.
depesz
signature.asc
Description:
On Sat, Jun 04, 2005 at 02:07:52PM +0200, PFC wrote:
don't forget to mention all the index columns in the order by, or
the planner won't use it.
of course.
i understand the concept. actually i find kind of ashamed i did not try
it before.
anyway - thanks for great tip.
depesz
update: 0.1 second
something like this.
is it possible?
will it be ever possible?
hubert
--
hubert lubaczewski
Network Operations Center
eo Networks Sp. z o.o.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
should be able to spped them up with some performance review
of trigger code.
depesz
--
hubert lubaczewski
Network Operations Center
eo Networks Sp. z o.o.
signature.asc
Description: Digital signature
that because it's bleeding edge, it
might destroy your data and it might behave differently than released
versions.
great. this is exactly what i need. thanks for hint.
depesz
--
hubert lubaczewski
Network Operations Center
eo Networks Sp. z o.o.
signature.asc
Description: Digital signature