it there a possibility that there is an error in the docker image after doing everything exactly as shown i can find the installed extensions only extension i can list using \dx command is plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
@awakenwithoutcoffee12 күн бұрын
lovely like usual , there is indeed allot to learn but were getting closer :) Bless you, ps. Regarding storing structured and unstructured data in the same table : are you using the technique to store complete structured tables inside a JSONB ? We thought about this approach but dropped it in favor of separating structured from unstructured data to prevent mis-matching and allow for better isolation/scaling. Still experimenting but currently our set-up creates 1 table per structured document and infer the SCHEMA dynamically on upload + the embedding. Than the Agent decides on run-time which tables to query on. Unstructured documents can be bundled together more easily but placing all document types together can give false-positive search results ?
@BertrandDunogier14 күн бұрын
Thank you, clear and straightforward.
@nanomartin16 күн бұрын
Quite useful tutorial! Thanks for bringing it. A few questions that come to my mind: 1- How could I get rid of proprietary image in docker? I bet it is possible to get our existing PG instance and just drop in the necessary extensions and should work as well, but just want to confirm. 2- It looks easy to delegate to the PG extension to communicate with ollama and get the embedings, however I see to many roundrtrips in that approach. For a programmatic system that would have to do tens of thousands runs a day, how this perform? Is there a more "straight" way to pull embeddings from ollama and query PG?
@awakenwithoutcoffee18 күн бұрын
great , looking forward learning how to utilize Timescale DB for our AI start-up !
@TimescaleDB18 күн бұрын
Awesome! That's great to hear. Please let us know how it goes, or if you have any questions. 😁
@awakenwithoutcoffee6 күн бұрын
@@TimescaleDB for sure!
@matarye974519 күн бұрын
Nice tutorial!
@TimescaleDB18 күн бұрын
Thanks!!
@activenode26 күн бұрын
You're not missing out much if you skip the first 15mins and jump to 15:00 right away
@PDKM-b1h27 күн бұрын
When I try to create hypertable, getting ""column type "timestamp without time zone" used for "Column" does not follow best practices,"" Error. The mentioned column is Tiimestamp
@dbanswan28 күн бұрын
Amazing video, learnt a lot. Will make time to read timescale blog regularly.
@TimescaleDB27 күн бұрын
Thanks! much appreciated
@BruntPixels123428 күн бұрын
You should do more tutorials like these
@TimescaleDB27 күн бұрын
What additional topics would you like to see? Let us know and we can make it happen.
@SageRap29 күн бұрын
Appreciate the video. Just FYI, you're pronouncing the word "build" like "bulled" throughout the video, but most native speakers pronounce it like "billed"
@raviraj8209Ай бұрын
What's difference between pgvector and pgai
@TimescaleDBАй бұрын
They're complementary extensions, you use them both together. pgvector brings a data type, pgai enables you to access LLMs from your db via SQL queries.
@raviraj8209Ай бұрын
@@TimescaleDB that's helpful. Thank you 🌻
@EricCoulthardАй бұрын
What other Metrics are available for Datadog? I already have CPU, Memory, and Disk available from doing a Postgres integration.
@avimehenwalАй бұрын
Wonderful video
@smritiverma78762 ай бұрын
Really enjoyed the presentation!! I was trying to understand how vacuum cleans up the indexes - would really love an explanation on the same.
@awakenwithoutcoffee2 ай бұрын
pleasantly surprised as I'm a fan of Lance his teachings. We are considering Timescale for our RAG solution(s).
@TimescaleDBАй бұрын
Awesome!
@HitAndMissLab2 ай бұрын
waste of time, DuckDB is x3 times faster.
@janesrodrigueslima41702 ай бұрын
Incrível, muito obrigado!!
@KITYDreams3 ай бұрын
7:40 time bucket function
@robsonl.95323 ай бұрын
I thought of making a question, but the autor hasn't answer anyone in that comments below! It's not worth to subscribe!
@yassinebouchoucha3 ай бұрын
Always enjoy lessons from industries leader and tech providers !
@imranrazakhan25693 ай бұрын
After importing and applying, it gives me following error After the apply operation, the provider still indicated an unknown value for timescale_service.service.password. │ All values must be known after apply, so this is always a bug in the provider and should be reported in the │ provider's own repository. Terraform will still save the other known object values in the state
@rembautimes88084 ай бұрын
Excellent video very bubbly personality. The Terminal sounded really snazzy 😂
@rembautimes88084 ай бұрын
Very nice video . I found out about timescale db from one of the KZbin influencers and having the ability to run it locally is a big plus. I was a bit afraid of running docker containers but this helps a lot
@miguelgranero17084 ай бұрын
top material team, despite the lack of views, this is gold.
@jonatasdp4 ай бұрын
Thanks for the feedback Miguel!
@hariprasadoo4 ай бұрын
What a fantastic conversation! Michael and Stephan's insights highlight PostgreSQL's incredible versatility and its potential to replace specialized tools like Elasticsearch. The deep dive into vector search and PostgreSQL's unique features was particularly enlightening. It's great to see industry leaders advocating for such a powerful and flexible database solution. Can't wait to explore more on how PostgreSQL can streamline and enhance our tech stacks! 🐘🔥
@stephanschmidt23345 ай бұрын
Loved to have talked to you, using Timescale in all of my projects.
@mikefreedman85475 ай бұрын
It was my pleasure, Stephan. Best of luck with the new book!
@EmdiHossain5 ай бұрын
dont waste your time.
@LightOurDirection5 ай бұрын
Baby data scientist here, this is so informative! thanks!
@mj4ever0015 ай бұрын
I couldn't get the gem to work with scenic gem, is there a special configuration to be done? i thought using create_view and passing the params should work, because that method should be overloaded by the extension but tit didn't work for me :( any idea?
@sj3145 ай бұрын
routing table to new cidr created to AWS console but not propagated to EC2 instance.
@mamyrak11145 ай бұрын
how we can do if we have a categorical variable like a region , a town , etc?
@LuCkY-sq7ge6 ай бұрын
How to join the slack ? Link doesnt work and says i need an invite
@vijaybrock6 ай бұрын
Hi Sir, Can you suggest me the best approach that suits to build a RAG app for multiple 10K Reports?
@MrIsaacbabsky6 ай бұрын
This is a MUST watch video for everyone, even skilled ones, as it's like an prime vision of the AS IS of RAG but with a glimpse of the TO BE.
@TimescaleDB6 ай бұрын
We agree!
@TrollAndOn6 ай бұрын
Hi, nice video on advancing RAG to a new level. I'm curious about SQLconnectors, how does this work under the hood? Do you only retrieve the schema of the table or does it share similiar functionality to SQLAgent from langchain?
@TimescaleDB6 ай бұрын
I think so, you can see the LlamaIndex docs for more details (see video description for links)
@theholyduality6 ай бұрын
This video has wrong info, no? Timescale throws errors if both the end_offset and start_offset arent at least twice the bucket width. In examples given in this video, the end_offset is much smaller than the bucket width. Is this something that has changed over time?
@techxball6 ай бұрын
This is great!
@ruslanklymenko10196 ай бұрын
any chance to get offset for time_bucket_gapfill ?((
@simonwilliams33996 ай бұрын
This is a great summary. Thank you!
@TimescaleDB6 ай бұрын
Glad it was helpful!
@djmed81936 ай бұрын
how you can filter on the symbol column without selecting it (where you use Amazone example) ?
@vimalaathythan37987 ай бұрын
my table has june 1 and 2 data. but when i create a materialized view it generates may 31 itself. CREATE MATERIALIZED VIEW daily_avg_temperature WITH (timescaledb.continuous) AS SELECT time_bucket(INTERVAL '1 day', time_column) AS day, device, AVG(max_temperature) FROM pandas GROUP BY day, device; what is the issue
@vimalaathythan37987 ай бұрын
my table has june 1 and 2 data. but when i created a materialized view with timescale continuous aggregate it generates a value for may 31 itself which not in the table. CREATE MATERIALIZED VIEW daily_avg_temperature WITH (timescaledb.continuous) AS SELECT time_bucket(INTERVAL '1 day', time_column) AS day, device, AVG(max_temperature) FROM pandas GROUP BY day, device; what is the issue
@adarshkumarmishra47517 ай бұрын
In my case time is present in the "ts" column and the value present in Unix format wants to see last 24 hrs data how we can see
@adarshkumarmishra47517 ай бұрын
In my case time is present in the "ts" column and the value present in Unix format wants to see last 24 hrs data how we can see
@vimalaathythan37987 ай бұрын
my table has june 1 and 2 data. but when i create a materialized view it includes may 31 also. CREATE MATERIALIZED VIEW daily_avg_temperature WITH (timescaledb.continuous) AS SELECT time_bucket(INTERVAL '1 day', time_column) AS day, device, AVG(max_temperature) FROM pandas GROUP BY day, device; what is the issue
@BabaykaMoscow7 ай бұрын
How would you make continuous aggregate if data is stored in jsonb and differs from sensor to sensor? Imagine I have one sensor with temperature and humidity and another one with wind speed & wind direction. All the data is kept in a flexible struct fashion as jsonb. Is it possible to create 1 hour continuous aggregate with avg, min & max out of this data? Thanks!
@christian_available7 ай бұрын
In other dataflow libraries the intervals require a time anchor reference point. For example you would clarify that 5 min intervals begin at 00:00pm, 00:05pm, 00:10pm etc and not 00:01pm, 00:06pm, 00:11pm. How does Timescale do this? Is it defaulted to midnight UTC?