circle @> box, polygon points access

2024-11-21 Thread Thomas Simpson
Hi Looking through the archives, around 20 years ago someone asked about getting a list of points from a polygon [15 AUG 2004] and the reply was this was not available but something like point(polygon, n) could be added relatively easily as a new feature to extract points. I'm hitting an iss

Re: Enhance pg_dump multi-threaded streaming (WAS: Re: filesystem full during vacuum - space recovery issues)

2024-07-23 Thread Thomas Simpson
below). On 22-Jul-2024 11:50, Andrew Dunstan wrote: On 2024-07-19 Fr 9:46 AM, Thomas Simpson wrote: Hi Scott, I realize some of the background was snipped on what I sent to the hacker list, I'll try to fill in the details. Short background is very large database ran out of space d

Re: Enhance pg_dump multi-threaded streaming (WAS: Re: filesystem full during vacuum - space recovery issues)

2024-07-19 Thread Thomas Simpson
Hi Scott, I realize some of the background was snipped on what I sent to the hacker list, I'll try to fill in the details. Short background is very large database ran out of space during vacuum full taking down the server.  There is a replica which was applying the WALs and so it too ran out

Enhance pg_dump multi-threaded streaming (WAS: Re: filesystem full during vacuum - space recovery issues)

2024-07-19 Thread Thomas Simpson
ossible. Thanks Tom On Thu, Jul 18, 2024 at 4:55 PM Thomas Simpson wrote: On 18-Jul-2024 16:32, Ron Johnson wrote: On Thu, Jul 18, 2024 at 3:01 PM Thomas Simpson wrote: [snip] [BTW, v9.6 which I know is old but this server is stuck there] [snip] I k