Re: Monthly table partitioning for fast purges?
От | Ron Johnson |
---|---|
Тема | Re: Monthly table partitioning for fast purges? |
Дата | |
Msg-id | 1060026088.1987.84.camel@haggis обсуждение исходный текст |
Ответ на | Re: Monthly table partitioning for fast purges? (Benjamin Jury <benjamin.jury@mpuk.com>) |
Список | pgsql-general |
On Mon, 2003-08-04 at 09:02, Benjamin Jury wrote: > You could create an index on the function date(), which strips the time > information. How much of a hit would there be if he had separate "monthly tables" and UNIONed them? > > -----Original Message----- > > From: psql-mail@freeuk.com [mailto:psql-mail@freeuk.com] > > Sent: 04 August 2003 14:01 > > To: PgSQL General ML > > Subject: Re: [GENERAL] Monthly table partitioning for fast purges? > > > > > > I am looking at ways to speed up queries, the most common way by for > > queries to be constrianed is by date range. I have indexed the date > > column. Queries are still slower than i would like. > > ... > > > The date column is of type timestamp (and so goes right down > > to seconds) > > , most user queries are only concerned about whole days without the > > times, (but hte time data is required for other queries) can i do > > something with an index of the timestamps cast to dates? and > > then cast > > the queries to dates too? -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+
В списке pgsql-general по дате отправления: