On 2023-10-26 11:56:56 +0200, Olivier Gautherot wrote:
> El jue, 26 oct 2023 11:15, Peter J. Holzer escribió:
> On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> > El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> > Okey, I see no one was be able to solve this problem. B
Hi,
El jue, 26 oct 2023 11:15, Peter J. Holzer escribió:
> On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> > El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> > Okey, I see no one was be able to solve this problem. But I could.
> May be
> > for someone this will be useful to
On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> Okey, I see no one was be able to solve this problem. But I could. May be
> for someone this will be useful too. There is solution.
[...]
> Now query is:
>
> SELECT genera
Hi,
El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> Okey, I see no one was be able to solve this problem. But I could. May be
> for someone this will be useful too. There is solution.
>
> Original query was:
>
> > 23 окт. 2023 г., в 18:13, Олег Самойлов написал(а):
> >
> > SELECT id/10
Okey, I see no one was be able to solve this problem. But I could. May be for
someone this will be useful too. There is solution.
Original query was:
> 23 окт. 2023 г., в 18:13, Олег Самойлов написал(а):
>
> SELECT id/1000 as partition
> FROM delivery
> GROUP BY partition
> HAVING ma
On Mon, 23 Oct 2023 at 17:42, Олег Самойлов wrote:
> Well, get list of partitions and later scan one by one all 100 partitions is
> too simple. :) I am interesting is here more elegant way? Any rewriting the
> query, any creating an index are permitted.
1.- You do not scan all partitions. Had y
On 10/23/23 10:13, Олег Самойлов wrote:
Back pardon, but I have a very newbie question. I have a partitioned table,
partitioned by primary bigint key, size of partition 1000. I need to get
the number of partition which need to archive, which has all rows are olden
then 3 month. Here is que
This is not correct. An index can accelerate, for instance, max(). Here is also
not WHERE or ORDER BY, but index is useful:
select max(created_at) from delivery;
> 23 окт. 2023 г., в 18:23, Toomas написал(а):
>
>
> There is no reason to use index. The query has neither WHERE nor ORDER BY
> cl
Well, get list of partitions and later scan one by one all 100 partitions is
too simple. :) I am interesting is here more elegant way? Any rewriting the
query, any creating an index are permitted.
> 23 окт. 2023 г., в 18:25, Francisco Olarte
> написал(а):
>
> On Mon, 23 Oct 2023 at 17:14, Оле
On Mon, 23 Oct 2023 at 17:14, Олег Самойлов wrote:
> Back pardon, but I have a very newbie question. I have a partitioned table,
> partitioned by primary bigint key, size of partition 1000. I need to get
> the number of partition which need to archive, which has all rows are olden
> then 3
There is no reason to use index. The query has neither WHERE nor ORDER BY
clause.
Toomas
> On 23. Oct 2023, at 18:13, Олег Самойлов wrote:
>
> Back pardon, but I have a very newbie question. I have a partitioned table,
> partitioned by primary bigint key, size of partition 1000. I need
11 matches
Mail list logo
